Urgent: Calling out Only the most recent value greater than 0 for each row

[jboy]

Dear All,

Please help!

I have a table containing different items in a row and each Items have values for 3 Periods. I want to create a column that gives only the most recent value that is greater than 0.

just as an example, if Period A = 0, then show value for Period B, if Period B = 0 and Period A = 0 then show value for Period C.

Thanks in Advance

[Mauritz_SA]

Hi @jboy 

Just wondering why you don't just use a nested if?

if([Period A] <> 0, [Period A],if([Period B] <> 0,[Period B],[Period C]))

Regards,

Mauritz