4 Replies Latest reply: May 21, 2014 4:44 AM by Marcin Szaleniec

Sum if values last year more then 0

Hello,

Could anybody help me with one problem?

I neet to build a pivot table where one of expressions is sum of sales. But I would like to sum up sales in only those units which reported any sales in the corresponding period of the last year. Simply, I would like to sum up sales of stores that worked/existed last year. Should I use set analysis (how) or some fancy 'if' formula?

Marcin

• Re: Sum if values last year more then 0

Sum({\$ <year={2013}>} Sales)

this expression sum all sales where year (you need a field year) is equal to 2013

Let me know

• Re: Sum if values last year more then 0

Marcin,

See if that helps you:

sum( {\$<Sales= {“=Sum({1<Year= {2013}>} Sales) > 0”}>} Sales)

• Re: Sum if values last year more then 0

Rogerio, it seems to be the correct answer to my question. Thanks.

• Re: Sum if values last year more then 0

Sum({\$<Year={\$(=Max(Year))}>} Sales)

Your sales being > 0 I would add a flag in the back end if you want to sum it, does it require aggregation etc?