Multi row function to find the previous month price and cogs

[lintorrey]

Hi there,

I need to find the price/t and cogs/t from the previous months for the Year Period has volumes (column Volume Last Mith Mix).

I used Multi row function and wrote the expression as follows but it didn't work. please help and thank in advance!

IF NOT IsNull([Volume Last Mth Mix]) AND
IsNull([price/t])
THEN [Row-1:price/t]
ELSE [price/t]
ENDIF

[Gaurav_Dhama_]

Hi @lintorrey,

Use the below formula instead.

if !isnull([Volume Last Mth Mix]) and isnull([price/t]) then [Row-1:price/t] else [price/t] endif

[Raj]

@lintorrey 
replace "NOT" with "!" and this should work.