Hi,
I've recently been contact by our finance team with the below query - I wondered if someone could help point out where in the existing formula I can tweak to resolve.
OLD Formula:
NEW Formula:
This has resulted in incorrect output in the field known as 'B6', please could you help me work out what i need to amend in the below formula?
OLD Output:
New Output:
Interesting formula change.
Not sure why you're getting a large negative number. Would need more context and details about what you're trying to do.
Hi@lcapon
Can you help me understand why do you think the result is wrong. Your B6 formula is E - (B1+B2+B3+B4). If you are changing your B4 formula and thus the value(List item 107's B4 value went from 0 to 248128), your B6 would get reduced by 248128, which is what i see happening (B6 goes from 0 to -248128). I would say this is what you've arithmetically tried to do.
If you feel the calculation is incorrect, maybe you need to check with Finance whether B6 calculation for subcontractor is different from POs.
This is my best understanding from the information presented