–section-----------------------------------
+++++++A B
product a 1 3
product b -5 7
–section-----------------------------------
+++++++A B
product a 2 -4
product b -4 2
–Total---------------------------------------
A B
-2 6
The numbers in the section is a result of severel numbers beeing calculated.
If we look at product a. The sum of A and B is 4 in the first section and -2 in the second. I want to sum pr product the totals that are positive (greater then 0). In this case the result would be 4.
I have a varaible that sums A and B column called
So I have tried "= where ( > 0) which gives syntax error.
Hi,
Check https://bobj-board.org/t/15226/18.
You can’t use the “>” operator on WHERE clause.
On link above there’s a suggestion to resolve the problem.