MultiRow Formula applied to more than one column in a single step

Question

Im applying succesfuly the folowing formula using the Multi-Row Formula, and I need to apply the same to several columns, is there a way to achive that on a single step? im thinking on the Multi-Field Formula, but how can I translate this formula once I have selected the columns?

Thanks ahead for your advice.

IF IsNull([Row-1:score]) THEN Null()
ELSE [score]-[Row-1:score]
ENDIF

Raj · Answer

@grazitti_sapna @binu_acs  Thanks for letting me Know !!

Have a great day

Raj · Answer

@Qiu thank you for sharing!

l don't know how I missed this.

grazitti_sapna · Answer

@Raj , you will have to do exactly what @Qiu suggested. You need to transpose the columns after adding an ID column to identify records on which you want to apply the above calculation and then use Multi-Row Formula.