Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Couldn't recognize an error in the below code. Please help.
SUM({$< Rep_Day = {$(#=ReportDay)}> * $< Rep_Month = {$(#=ReportMonth)}>} Deposit_Amount)
Regards,
Shumail
Hi,
SUM({$< Rep_Day = {$(#=ReportDay)} , Rep_Month = {$(#=ReportMonth)}>} Deposit_Amount)
Tried the same earlier but not working
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)
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)))