topic Set Analysis not working in App Development

Set Analysis not working

arusanah — Wed, 01 Aug 2018 15:07:57 GMT

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!

Re: Set Analysis not working

YoussefBelloum — Wed, 01 Aug 2018 15:30:32 GMT

Hi,

try this:

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

Re: Set Analysis not working

arusanah — Wed, 01 Aug 2018 16:45:05 GMT

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 .

Re: Set Analysis not working

Chanty4u — Wed, 01 Aug 2018 17:00:43 GMT

may be this?

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

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

Re: Set Analysis not working

arusanah — Wed, 01 Aug 2018 17:04:55 GMT

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

Re: Set Analysis not working

Chanty4u — Wed, 01 Aug 2018 17:09:07 GMT

try

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

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