Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I am having a problem with a set analysis. I need the sum where Arrangement={'Hourly'} but I also need to give the alternative to whatever is selected.
Basically I am trying to add {$<Arrangement={'Hourly'>} to Sum({1-$}WIP_Total_Fees).
Thank you!!!
Alternative to whatever is selected? Not sure I understand....
With regards to adding the set in there, try this:
Sum({1-$<Arrangement={'Hourly'}>} WIP_Total_Fees)
So there are filters and drill downs, and I need the alternative to what is selected by the filters/drills. I need the selected of Arrangement=Hourly to remain regardless.
May be this:
Sum({<Arrangement={'Hourly'}>} WIP_Total_Fees)
The above will filter based on all selections, except Arrangement which will always be Hourly
But I need the alternative of the selections
I got it....
May be this:
Sum({1-$<Arrangement -= {'Hourly'}>} WIP_Total_Fees)
I figured it out. Thanks!
What was it? Can you share with us?
Sure. It was more that I was thinking about it the wrong way. I just did
Sum({$<Arrangement={'Hourly'}>}WIP_Total_Fees-WIP_Fees1)/Sum({1<Arrangement={'Hourly'}>}WIP_Total_Fees-WIP_Fees1)
And it accomplished the same thing.
Thanks!