Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a dashboard with [Month] as a filter. Only one value for [Month] can be selected at a time.
I'm using the code:
sum({<TransitionMonth=${"=GetFieldSelections(Month)"} , Version={'ABC'}>}Value)
and with 'Aug' filtered for [Month], I'm getting the 4th column in the below table:
What I need is for each row to give me the value of 2.2, since that is value for [TransitionMonth]=[Month]=Aug.
What am I doing wrong?
This worked!
sum(total{<TransitionMonth={'$(=getfieldselections(Month))'} , Version={'1YP'}>}Inflows)*change/100
It was missing a TOTAL function
Hi,
try this:
sum({<TransitionMonth={'$(=getfieldselections(Month))'}>} , Version={'ABC'}>}Value)
It displays null.
Try :
sum({<TransitionMonth={"$(=concat(Month,'","'))"}>} , Version={'ABC'}>}Value)
My bad, it was a mistake, try this:
sum({<TransitionMonth={'$(=getfieldselections(Month))'} , Version={'ABC'}>}Value)
Didn't pay attention to the "one month selection part" ;
But even in this case, with concat it should work for one or different Months selection while I'm not that sure It would work with GetFieldSelections(Month) if more than one month is selected..
Youssef, This gives '2.2' for Aug, but zero for all other months.
Yes that's why I removed my comment, because when I use CONCAT it's often when I select multiple values.
#مريجل صاحبي
check suppress when null in "complement"
Is there a way to do it without using GetFieldSelections?