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

[Davidmg1982D]

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]

I don't think so multi-field formula will work in this case.

[Qiu]

@Davidmg1982D 
I usually use a Transpose tool to bring the necessary coloumns into one then do the calculation, then follow with Cross Tab tool

[binuacs]

@Raj yes, this can be done by transposing the data as @Qiu did

[grazitti_sapna]

@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.

[Raj]

@Qiu thank you for sharing!

l don't know how I missed this.

[Raj]

@grazitti_sapna @binuacs  Thanks for letting me Know !!

Have a great day