02-24-2017 03:23 PM
I want the report users to have the capability to calculate the Product of obs in Variable VALUE based on the MONTH_END_DATE selection.
Let's say I have a slider with MONTH_END_DATE value in it which gives a user the flxeiblity to choose a period. Once they have choosen a begining and ending period of their choice, I want to display the product of all observations for variable VALUE.
For example: User select JAN2015-MAR2015 in the slider, I want to display Product of the 3 obs in that period (0.988*1.035*.995)
It can be done very easily in Excel, Is there a way to do it in VA.
<see the attachment>
02-27-2017 10:44 AM
If I understand correctly, you want basically want an aggregation type that multiplies the values together in the same way that the SUM aggregation adds the values together.
Is that right?
I don't think there is a way to do this currently. Can you explain the scenario where this type of calculation is needed?
02-27-2017 11:31 AM
Yes. I have monthly return for last 10 years. I have to calculate compunded return for a selected time period in the date slider.
02-27-2017 11:38 AM
02-27-2017 12:54 PM
02-28-2017 12:28 PM
03-20-2017 01:46 PM
@Sam_SAS I was able to resolve it using Base SAS. I have updated the idea for future product developements. If you are interetsed I can walk you through my requirement and show you how I resolved it.
03-20-2017 01:55 PM
That is good to hear!
I looked for your idea but I can't seem to find it. Can you post a link?
It would be best for us if you could post your requirements and your workaround there.
03-20-2017 03:11 PM - edited 03-20-2017 03:12 PM