Set Analysis Error

[shumailh]

Couldn't recognize an error in the below code. Please help.

SUM({$< Rep_Day = {$(#=ReportDay)}> * $< Rep_Month = {$(#=ReportMonth)}>} Deposit_Amount)

Regards,
Shumail

[syed_muzammil]

Hi,

SUM({$< Rep_Day = {$(#=ReportDay)} , Rep_Month = {$(#=ReportMonth)}>} Deposit_Amount)

[shumailh]

Tried the same earlier but not working

[syed_muzammil]

Hi,

What is it you actually want to do? Try using num() . Added the = sign.

SUM({$< Rep_Day = {$(num(=ReportDay))} , Rep_Month = {$(=num(ReportMonth))}>} Deposit_Amount)

[shumailh]

I try the below code and it's working but not working using set analysis

SUM( if(Rep_Day = $(#=ReportDay), if(Rep_Month = $(#=ReportMonth), Deposit_Amount, 0)))