Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have [Month] as a filter. I want to be able to select certain months at a random order and run a part of a code for those Months alone.
if(GetSelectedCount([Change])=1 and GetSelectedCount(Month)=1 ,
if(avg(TransitionMonthNum)>=num(Month),
Rangesum(above(total(sum({<Version={'1YP'}>}Value)),0,rowno(total)))
+ sum(total {<TransitionMonth={'$(=getfieldselections(Month))'} , Version={'1YP'}>}Value)*[Change]/100,
Rangesum(above(total(sum({<Version={'1YP'}>}Value)),0,rowno(total)))
)
)
The above code works when only one [Month] is selected. I want this to run when GetSelectedCount(Month)>1 and have the values from GetFieldSelections(Month) in an array or something, and then create a loop, so that the code works for all the months selected.
What would be the best way to do this?
The Output I have now is something like this:
I want to be able to do this for multiple Months.
stalwar1 It's very sensitive data and I have to de-sensitize it before I can send it to you. Let me know if the image helps at all.
Thanks.
When you say that you want to do this for multiple months, what exactly do you mean? See more than 7 months you see now?
No, I will still see 7 months. In the graph above, the line starts diverging in Aug because that's the filter I have selected. The [Value] for Aug decreases by 20%. If I want to know what happens if we change [Value] by 20% for both Aug and Sep, the graph should be able to show that.
So, this is starting to make a lot more sense. What happens when you select 2 months without any changes? Errors out? incorrect result?
It displays nothing.