Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I add the if statement into the following sum?
=sum({<
[BadRate.Quarter] = {$(=$(vQuarterLLP))}
>}
[BadRate.Mature_BR3_F3])
if statement:
if [BadRate.Mature_BR3_F3] = 0, null(), [BadRate.Mature_BR3_F3]
Thanks!
Perhaps this
=sum({<[BadRate.Quarter] = {$(=$(vQuarterLLP))}>} If([BadRate.Mature_BR3_F3] = 0, null(), [BadRate.Mature_BR3_F3]))