G
Geoff Newham
The Conditinal Sum Function is not recognising a column that calculates a
percentage of 3 other columns (e.g. (S-T)/R is a calculation that ends up in
V).
When filtering for conditions where one includes the total consideration of
all those at 0% and, then, at more than 0%, the calculation always returns 0.
Applying the other conditions independently of the % column is fine. As soon
as the % column is included, the result returns to 0.
On some occasions, in Step 2 of the Conditional Sum Wizard, selecting a
condition based on the % column returns #### in the value box before the
condition is added
percentage of 3 other columns (e.g. (S-T)/R is a calculation that ends up in
V).
When filtering for conditions where one includes the total consideration of
all those at 0% and, then, at more than 0%, the calculation always returns 0.
Applying the other conditions independently of the % column is fine. As soon
as the % column is included, the result returns to 0.
On some occasions, in Step 2 of the Conditional Sum Wizard, selecting a
condition based on the % column returns #### in the value box before the
condition is added