sum on selected values

[ArturJ]

Hello,

I'm trying to sum Incomes witout invoices with turnover between o and 50. Any suggestione are welcome

[RafaelBarrios · Accepted solution]

hi @ArturJ 

i think it is not very clear what you need, maybe you can paste some records to give us a clue.

but first i would Flag in the script those incomes without invoices.

Something like

load
....
....
if(isnull(invoice_number),0,1) as invoice_flag,
....
from <where ever>

now, in your set analysis you can do something like this

sum({<  invoice_flag={0}, turnover={">0<=50"} >} income)

hope it helps

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!