Dealing with absolute values

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

Preparation

Accepted answers

Qiu

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

0516-Sifiso.yxmd

All comments

Qiu

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

0516-Sifiso.yxmd

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_workflow.yxmd

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

Sifiso

Thank you sir

Qiu

@grazitti_sapna
Thank you for taking up the question. 😁

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703