Skip navigation

2 Replies Latest reply on May 18, 2017 9:14 PM by Prayson Wilfred Daniel

Something wrong with formula to give simple calculation wrong answer?

Matthew Mizuguchi May 18, 2017 6:36 PM

I am making a headcount with some data I made up and I am almost there but I encountered an issue with my 'existing' column my formula for it is (ending balance + term - new) it should produce the correct numbers for the column but a few rows are not correct: 'First Allied' and 'Girard' I do not see where the issue is. Any help is appreciated

2016-10 Advisors.xlsx 311.9 KB
Test Head Count demo.twbx 32.1 KB

1. Re: Something wrong with formula to give simple calculation wrong answer?

Ritesh Bisht May 18, 2017 9:14 PM (in response to Matthew Mizuguchi)
I am not sure about the use of include calculation that you have made .

If I keep actual Flow in Existing calculation then it is working.

Below I have correct value for First_Allied as 7+3-7=7 & Girard as 3+8 - 4=7

Please find attachment as well.

Thanks,
Ritesh

Test Head Count demo_ribisht.twbx 83.9 KB
Like Show 0 Likes(0)

Actions
2. Re: Something wrong with formula to give simple calculation wrong answer?

Prayson Wilfred Daniel May 18, 2017 9:14 PM (in response to Matthew Mizuguchi)

What is your expected result? Should it be 37?
Like Show 0 Likes(0)

Actions

Go to original post

More Like This