Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone, I have a question. I cant do it on dimension so is purely on set analysis expressions.
sum({<Day(Date1)=(Day(Date2))}>} Revenue)
Basically i want to sum the revenue if the DAY for Date 1 and Date 2 are on the same DAY.
i.e
Customer booked a hotel room on nov 11 (Date1) and checking in on the date itelf (nov 11), i would want to count these on the same date check in itself on the revenue.
I cant do in script nor dimension.
How should i do
hi,
you can use if(Date1=Date2,sum(Revenue),null())
try
sum(if(day(Date1) = day(Date2),Revenue)
simple could be to add a flag in the script so that your set analysis becomes simple and improve the performance
if(Date1=Date2,1,0) as Flag
sum({<Flag={1}>}Revenue)
Hi Ben,
Find the attached QVW file, it may help you.
R/Murali