How to make condition to compare previous value with the current value?

[#1]

Hi all,

I want to make if function. And my condition is to compare value in previous dimension with the current value in dimension.

Part No	Status	Production_Order	Issue	Yield
1AH391M04432	Complete	0 1100 00001 75 0	1,152	1,128
1AH391M04432	Complete	0 1100 00001 75 1	1,152	1,124
1AH391M04432	Complete	0 1100 00001 75 2	1,152	1,116

In above table,I want to make expression when Issue in previous Production_Order equal with Issue in current Production_Order.

I try to use "previous" function, but it's not work for me. Can anyone have suggested for this problem?

[#2]

hello..

i hope this can help u

this one is for expresion

yesterday:

Sum ({$<mst_date={"$(=date(max(mst_date)-1))"}>} amount)

current:

Sum ({$<mst_date={"$(=Max(mst_date))"}>} amount)

or u maybe can make a table for yesterday data and a table for current data

[Miguel_Angel_Baeyens]

Hello,

If you are working on an expression, you my use inter-record functions: below(), above(), after()... Take into account the position if you are using a pivot table.

Regards