Set analysis - positive transactions from selected month

[#1]

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])

[nathanfurby]

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.

[swarup_malli]

NathanFurby,

that was perfect

Thanks

Swarup

[rrsrini2907]

Since you have set Analysis, you can try using like this

sum ({$<Month = {"<=$(=Month)"}>,[Recorded amount]={">0"}} [Recorded amount])

Regards,

Srini.

[#5]

Hi,

correct answer is:

sum({$<Month={"<=$(=Month)"}, [Recorded amount]={">0"}>} [Recorded amount])

Thanks!