Subtracting ROW-1 in Column A with ROW-2 in Column B (A2-B1)

Question

Hi,

I want to subtract 2 numbers in the below format

Thank you in advance

ABDifferenceFormula79238-14252-238' (A2-B1)252385-15400-385'40098

RolandSchubert · Accepted Answer

Hi @Anaz_S ,

the Multi-Row Formula tool should solve the problem - attached a sample workflow.

Hope this is helpful.

Best,

Roland

afv2688 · Accepted Answer

Hello @Anaz_S ,

you could use the multi-row formula for that.

IIF(IsNull([Row+1:A]),0,[Row+1:A]-[B])

Didn't know what you wanted to do with the last value so I did put a 0 in it.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Anaz_S · Accepted Answer

Getting the below error

Formula: invalid type in subtraction operator in Multi-Row function
Tried typing - manually and tried selecting the operator field and selected subtraction (once subtraction is selected automatically the - symbol will reflect in the expression)
(Is it any configuration issue)
The subtraction operator is  working properly in Formula function

afv2688 · Accepted Answer

Hello @Anaz_S ,

Put a select tool before the multi row and check the data types, they should be numeric both columns.

Regards