Set Analysis not working

[arusanah]

Hi Friends ,

I'm writing two expression one with simple sum(if()) and other one using set Analysis . both are giving me different answers .

sum(if(CASH_DATE<=[Snapshot Date],CASH_AMOUNT,0)) --gives me correct number

Sum({< CASH_DATE={"<= $([Snapshot Date])"}>}  CASH_AMOUNT)
-- take my numbers off

Please help me find out error with my set expression.

Any help is greatly appreciated!

[YoussefBelloum · Accepted solution]

Hi,

try this:

Sum({< CASH_DATE={"<=$(=[Snapshot Date])"}>}  CASH_AMOUNT)

[arusanah]

Thank you Youssef ,whit above expression I need to make selection on snapshot filter to see numbers . I tried to update above expression to see max snapshot date data

if(isnull(getfieldselections([Snapshot Date])),Sum({< CASH_DATE={"=max([Snapshot Date])"}>}  CASH_AMOUNT),

Sum({<{"<=$(=[Snapshot Date])"}>}  CASH_AMOUNT))

but this shows sum of all transactions and not just max date when nothing is selected .

[Chanty4u]

may be this?

if(isnull(getfieldselections([Snapshot Date])),Sum({< CASH_DATE={"$(=max([Snapshot Date]))"}>}  CASH_AMOUNT),

Sum({<{"<=$(=[Snapshot Date])"}>}  CASH_AMOUNT))

[arusanah]

Thanks Chanty But this doesn't work either , already tried

[Chanty4u]

try

CASH_DATE= {'$(=Max([Snapshot Date]))'}

or

CASH_DATE= {'$(=Max([Snapshot Date]))'}

or

CASH_DATE= {'$(=date(max([Snapshot Date])))'}