Set analysis and if inside value

[#1]

Hi,

I have a little problem. I would like to have if-statement to decide my value within the set analysis.

Here is what I have tried:

varMaxDate is a variable, that holds the max date.

And I don't actually use YYYY or WW fields, I just needed to change them for security reasons.

=sum({<WW={'(if(isNull(GetFieldSelections(WW)),week(varMaxDate),WW))'}, YYYY={'(if(isNull(GetFieldSelections(YYYY)),year(varMaxDate),YYYY)'} >}#1)

Cheers,

Niko

[sunny_talwar · Accepted solution]

Try this:

=Sum({<WW={'$(=If(IsNull(GetFieldSelections(WW)), Week(varMaxDate), WW))'}, YYYY={'$(=If(IsNull(GetFieldSelections(YYYY)), Year(varMaxDate), YYYY))'}>} #1)

[#3]

Well that worked well, thank you!