Set analysis expression to exclude Date selection

[ramyasaiqv]

Sum(If(YYYYMM=Max(total {<[Amount]={"=Len(trim([Amount] ))>0"}>} YYYYMM), Amount,

If(mod(MonthNum,3)=0 , Amount)))/Count(distinct TOTAL [item])

I have this expression and is used in chart that works fine. I have a list box with “Date” and I want the above expression should be independent of “Date” selection

I’m struggling to include ({$<[Date]= >} in the above expression so that the expression will be independent of “Date” selection. Please can someone help me in writing the correct set expression . Thank you,

Ramya

[techvarun]

May be?

Sum(If(YYYYMM=Max(total {<[Amount]={"=Len(trim([Amount] ))>0"}, Date = {'*'}>} YYYYMM), Amount,

If(mod(MonthNum,3)=0 , Amount)))/Count(distinct TOTAL [item])

[tresesco · Accepted solution]

Try incorporating the date selection ignorance (using set) in all the aggregation functions, like:

Sum( {<Date>} If(YYYYMM=Max(total {<Date, [Amount]={"=Len(trim([Amount] ))>0"}>} YYYYMM), Amount,

If(mod(MonthNum,3)=0 , Amount)))/Count(distinct TOTAL {<Date>} [item])

[its_anandrjs]

Try with

Sum(If(YYYYMM=Max(total {<[Amount]={"=Len(trim([Amount] ))>0"},DateField=>} YYYYMM), Amount,

If(mod(MonthNum,3)=0 , Amount)))/Count(distinct TOTAL [item])

[ramyasaiqv]

It worked. Thank you Tesesco.

[ramyasaiqv]

Thank you for the response Anand.

[ramyasaiqv]

Thank you for the response Varun.