Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

expression is right ?

(Sum (if("Date d'entrée") < ('31/01')  and GetFieldSelections(year))

and

(Sum ( if ([Date de sortie]) => ('01/01') and GetFieldSelections(year))))

1 Reply
jwjackso
Specialist III
Specialist III

If these are date fields,

=Sum({<[Date d'entrée]={"<$(=MakeDate(GetFieldSelections(year),01,31))"},[Date de sortie]={">=$(=MakeDate(GetFieldSelections(year),01,31))"}>} SomeAmt)