Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attempting to write an If Expression using a Date Field and the Today Function.
I currently have:
=IF(TestDate <= Today(), Sum(Cost), '-'))
However, I can only get the else portion of this IF statement to display. Where am I making a mistake in this expression?
I believe there are in the same format, however how would I format them to be the same in the event they weren't
If TestDate is a field, and there is more than one possible value in the context of this calculation, then TestDate will evaluate to null, so the expression will be false. Perhaps you need:
Sum(If(TestDate <= Today(), ...))
or
Sum({<TestDate = {"<=$(=Today())"}>} ....)