SET ANALYSIS - FORMULA PROBLEMATIC

[#1]

I am finding the following problematic:

=NUM(SUM({1<MONTH = {'$(vMaxMonth)'}>}Payment), '#,##0.##', '.' , ',')

This formula is still not ignoring my selections.

Please can I ask for advise

Thanks

George

[sunny_talwar]

What is your definition for the variable vMaxMonth? Is this an expression? You might need to ignore selection within the expression for this variable

[#3]

Hi

vMaxMonth==Max(MONTH)

Regrds

[sunny_talwar]

Try like this:

vMaxMonth = Max({1} MONTH)

[#5]

Thank you , perfect

[#6]

had to introduce other time dimensions, QTR and FY.

=sum({<MONTH={'$(vMaxMonth2)'}>}Payment)- Works perfectly

vMaxMonth2 defined as Max({1} MONTH)

But i also need to ensure that QTR and FY selections has no interaction when selected

Been trying the following :MAX({<MONTH = ,FY= ,QTR= >} MONTH) as variable but no result

[sunny_talwar]

Max({1} MONTH) won't interact with any selection. 1 within the curly brackets means that don't filter out based on any selection within any field. Are you seeing the results changing based on selection in QTR and FY?

[#8]

Yes

[sunny_talwar]

Would you be able to share a sample with us to see the issue?

[tresesco · Accepted solution]

Include your set in the Sum() as well like:  =sum({<FY, QTR, MONTH={'$(vMaxMonth2)'}>}Payment)