Button Action on the SUM of Multiple Fields (Equal and Not Equal to 0)

[#1]

Can anyone tell me the best way to transform this SQL Statement into an action in a Button?

SELECT *

WHERE ((GROSS_1+GROSS_2)<>0)

Basically, I want the button to select all values where the sum of GROSS1 OR GROSS2 are NOT Equal to Zero..

Example:

LINE# GROSS1      GROSS2

    1          0                   400

    2          400               800

    3          0                   0

So, LINES 1 & 2 should be returned at the click of the button.

The negation of that would be helpful too. (Values where GROSS1 AND GROSS2 = 0)

[sunny_talwar · Accepted solution]

Check out the attached application

[maxgro]

maybe you can add a flag (thanks Sunny, I used your .qvw)

Table:

LOAD * Inline [

LINE#, GROSS1, GROSS2

    1, 0,      400

    2, 400,    800

    3, 0,      0

    4,,

];

Left Join (Table)

LOAD LINE#,

if(sum(GROSS1) + sum(GROSS2)>0,1,0) as Flag

Resident Table

group by  LINE#;

and in the action of the buttons

[sunny_talwar]

No problem at all

[#5]

Thanks!!!