topic Re: How to modify set analysis to sum all periods selected? in App Development

How to modify set analysis to sum all periods selected?

WiscoSippi — Fri, 16 Sep 2016 14:04:52 GMT

Set analysis: Sum({<[Fiscal Period Counter Month] = {"$(=max([Fiscal Period Counter Month]))"}>} [Sales])

This works perfectly for its intended purpose. However, when we make selections it defaults to the Max fiscal period month selected. How do I code it to use max month unless selections are made? I've tried a handful of IF statements but to no avail.

First image: June doesn't have an "EHV" sale so nothing is shown. Second image: Only April and May selected but only May sales are shown.

Re: How to modify set analysis to sum all periods selected?

swuehl — Fri, 16 Sep 2016 20:05:21 GMT

Try maybe something like

=Sum(

{<[Fiscal Period Counter Month] *= {"$(=If(GetSelectedCount([Fiscal Period Counter Month]),'*',max([Fiscal Period Counter Month])))"}>}

[Sales])

Re: How to modify set analysis to sum all periods selected?

WiscoSippi — Fri, 16 Sep 2016 20:10:06 GMT

Thanks! I used a modified version of this using the GetSelectedCount function. Didn't know it existed before.

Re: How to modify set analysis to sum all periods selected?

swuehl — Fri, 16 Sep 2016 20:21:45 GMT

You are welcome.

How does your modification look like?

Re: How to modify set analysis to sum all periods selected?

WiscoSippi — Fri, 16 Sep 2016 20:30:30 GMT

I had to expand on it cover several scenarios and added a variable,vPeriodCurrentMonth, to contain the original Set Analysis

if(GetSelectedCount([Fiscal Period Month Year])=0 and GetSelectedCount([Profit Center Name])=0 and GetSelectedCount([LTC Type])=0 and GetSelectedCount([Customer Name])=0 and GetSelectedCount([MVA Class])=0

Sum( $(vPeriodCurrentMonth)

[Trans Sales]

)

+Sum( $(vPeriodCurrentMonth)

[Freight Sales]

)

+Sum( $(vPeriodCurrentMonth)

Rigging

Sum(

[Trans Sales]

)

+Sum(

[Freight Sales]

)

+Sum(

Rigging

))