Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to use the sum(if)-function for a specific selection (all values between 3999 and 5000). My idea is like this, but it doesen't work:
sum(if(booking> 3999 and booking< 5000, cost)) as cost_special
Thank you for your help!
try this
sum(rangeonly(if(booking>3999 and booking<5000,cost)as cost_special
Hi,
Try this
IF(SUM(booking)>3999 AND SUM(booking)<5000,cost) as cost_special
try this
sum(rangeonly(if(booking>3999 and booking<5000,cost)as cost_special
sum( total if(booking> 3999 and booking< 5000, cost)) as cost_special
Hi,
Try this
IF(SUM(booking)>3999 AND SUM(booking)<5000,SUM(cost)) as cost_special
sum({<booking={">3999<5000"}>}cost)
Thank you, but it doesn't work. QV says that there is a skript mistake.
Thank you, but it doesn't work. QV says that there is a skript mistake.
Set analysis wont work with script.Did you use Group by clause in your table
Load * sum(x)as tmp
from x.qvd group by y;
Thank you very much!! It works...