EXPRESSION

[yuech1]

Hi,everyone

there is ine app connect database

folowing are part of content.

we choice backlog_accessories_quantity,can find out that the opposite backlog_accessories_revenue have many value 0.

I want to exclude the number of backlog_accessories_quantity for the  value 0.

sum(backlog_accessories_quantity) ,do some change for this

[BrunPierre]

Hi @yuech1,

If I understood correctly, try the below expressions;

SUM({< backlog_accessories_revenue -= {0} >} backlog_accessories_quantity)

SUM(IF(backlog_accessories_revenue <> 0,backlog_accessories_quantity))

Best regards

[yuech1]

Yes! Correct!

i uesd this: 

Sum(backlog_accessories_quantity)-sum({<backlog_accessories_revenue={0}>} backlog_accessories_quantity)

firstly,i thought the same thing about the first one, but i wrote like below:

SUM({< backlog_accessories_revenue <> {0} >} backlog_accessories_quantity)

it's not work.  get new skill!

[BrunPierre · Accepted solution]

@yuech1  Kindly mark the answer as Correct/Helpful.