Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to sum Incomes witout invoices with turnover between o and 50. Any suggestione are welcome
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!
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!