Dealing with absolute values

[Sifiso]

Hi folks.

I want a formula that will look at [Local cost], if there are two equal numbers but opposite (2 598 200.935 & -2 598 200.935) THEN change [conversion rate] of the absolute number to match the opposite number.

This will help us eliminate the variation in the [main cost]

Desired results

[Qiu · Accepted solution]

@Sifiso 
We can create a new column for the abosolute "Local Cost" then group the data with it.

Using Multi-Row Formula tool can compare the two adjacent rows and update the value.

[grazitti_sapna]

Hi @Sifiso, try this workflow. I hope this helps!

If this post solves your purpose please mark this post as a solution.

Thanks!

[Sifiso]

Hi Qiu.

thanks for your help, it seems like there is something that I am doing fundamentally incorrect. I am getting the following error by the formula tool

[grazitti_sapna]

@Sifiso  as the error says that the field 32_Local- Cost Value is a string type field therefore I would suggest you to apply select tool and change the datatype of this field to double.

Thanks!

[Sifiso]

Thank you sir

[Qiu]

@grazitti_sapna 
Thank you for taking up the question. 😁