If statement

[Ayden]

hello there need help to rewrite this set analysis to an If statement to create a field at the script vs the front end.

sum({< [ Date]={">=$(vCurrentDay)"}>} Quantity)

[rbartley]

How about the following?

Sum(if([Date]=Date(Today(),'dd/MM/yyyy'),[Quantity])) as 'Quantity Today'  (change formatting of date as appropriate)

[justISO]

Hi, try

sum(If(date([Date])>= date($(vCurrentDay)), Quantity)

Additionally, you can change variable $(vCurrentDay) to actual formula, like date(today())