compare Each List Value

[#1]

Hi, ALL

Someone know that?

I want show like this

[Month]      [(MonthSales)]     [(LastMonthSales)]     [Compare(%)]

Now, I struggleed with LastMonthSales.

I thought ==>

=if((Month-1 >0),  Sum ({1<Month={"Month-1"}>}Sale), 'no')

but, not working.

how to resolve this..

thank you.

ED

[trey_bayne · Accepted solution]

Try using Above(Sales1) in the expression

[trey_bayne]

Also, if you want to get rid of the null you can do something like this in Sales2.

=if(isnull(Above(Sales1)),Sales1,Above(Sales1))

[#4]

Trey, Thank you

great thank you!!!

I solved it!