Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
please help me to write a script which show me only positive transaction quantities from selected month.
I don't know how to use AND in set analysis.
Below script which can show me sum of all transactions from selected month.
sum ({$<Month = {"<=$(=Month)"}> [Recorded amount])
If(
sum ({$<Month = {"<=$(=Month)"}> [Recorded amount])>0,
sum ({$<Month = {"<=$(=Month)"}> [Recorded amount])
)
Depends on what dimension you have in the chart. If you want to aggregate over a dimension not used in the chart then you will need to use the AGGR expression.
Since you have set Analysis, you can try using like this
sum ({$<Month = {"<=$(=Month)"}>,[Recorded amount]={">0"}} [Recorded amount])
Regards,
Srini.
Hi,
correct answer is:
sum({$<Month={"<=$(=Month)"}, [Recorded amount]={">0"}>} [Recorded amount])
Thanks!