Wrong formula results in Total / Result rows by active condition.
my doubt is the following one:
I have a query with a three columns
1) a column with Net sales (sales - returns): it can be <=> 0
2) a column with purchases
3) a Formula doing Sales %A Purchase
Everything works fine.
The problem lies in the condition that we have by Active by default (Net sales > 0).
Net Sales column is ok, only showing positive value rows, with Total or Result row showing up an addition for all remaining rows(adjusting the 'Result Calculated as "Total") in its properties.
However, the Formula is showing wrong values in the Totals (result) row, as it's using for the calculation, the result row WITHOUT the condition applied.
This error only happens in the total/result row, not for the rest of rows.
How can I get the correct operand (Total Net Sales restricted by active condition) to be used in the 3rd column (Formula).
Thanks in advance for your help.