Login Page - Create Account

Support Board


Date/Time: Fri, 10 Jan 2025 03:37:30 +0000



Post From: PIVOT formula incorrect

[2016-08-08 19:10:10]
User866531 - Posts: 14
Hi,
I have been trying to work around a mistake in the pivot formula type 10. I'm using it a lot more now and its become a bit of a problem.
The current formula prints the S4 level between the S2 and S3 levels.

There is a mistake in the formula.

Support Level 4 (S4) = S3 - (S2 - S1)

But it should be :

S4 = S3 – (S1 – S2)



Can this please be fixed?

Thanks