topic Re: Set Analysis Help in App Development

Set Analysis Help

Fri, 09 Dec 2016 16:00:35 GMT

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!!!

Re: Set Analysis Help

sunny_talwar — Fri, 09 Dec 2016 16:12:29 GMT

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)

Re: Set Analysis Help

Fri, 09 Dec 2016 16:27:28 GMT

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.

Re: Set Analysis Help

sunny_talwar — Fri, 09 Dec 2016 16:29:58 GMT

May be this:

Sum({<Arrangement={'Hourly'}>} WIP_Total_Fees)

The above will filter based on all selections, except Arrangement which will always be Hourly

Re: Set Analysis Help

Fri, 09 Dec 2016 16:31:01 GMT

But I need the alternative of the selections

Re: Set Analysis Help

sunny_talwar — Fri, 09 Dec 2016 16:34:24 GMT

I got it....

May be this:

Sum({1-$<Arrangement -= {'Hourly'}>} WIP_Total_Fees)

Re: Set Analysis Help

Fri, 09 Dec 2016 16:44:51 GMT

I figured it out. Thanks!

Re: Set Analysis Help

sunny_talwar — Fri, 09 Dec 2016 16:46:40 GMT

What was it? Can you share with us?

Re: Set Analysis Help

Fri, 09 Dec 2016 16:50:05 GMT

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!