Set Analysis

[#1]

Hi all

How to write this is set Analysis

=if(num(floor(Today()))=Num(Floor(AssignmentStart)),Sum(Qty),0)

Thanks

[MK_QSL]

What is your dimension?

[#3]

Order ID

[MK_QSL]

SUM({<Order ID = {"=Num(Floor(Today())) = Num(Floor(AssignmentStart))"} >}Qty)

[Peter_Cammaert]

Or this one. Maybe a bit easier to decypher. IMHO function InDay() is underrated...

=SUM({<Order ID = {"=InDay(AssignmentStart, Today(), 0)"}>} Qty)

[miguelbraga]

Make a field like this:

if(num(floor(Today()))=Num(Floor(AssignmentStart)),'1','0') as Flag

Then make a set analysis like this:

=sum({$<Flag = {'1'}>} Qty)

Simple as this

Regards,

MB

[effinty2112]

What about:

=sum(-Qty*inday(AssignmentStart,Today(),0))

?