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
Solved! Go to 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.
Hi @Sifiso, try this workflow. I hope this helps!
If this post solves your purpose please mark this post as a solution.
Thanks!
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
@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!
Thank you sir
@grazitti_sapna
Thank you for taking up the question. 😁