Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm working with 2 dates. If I add a Calculated dimension like
[SalesDocumentConfirmedScheduleLine.Delivery date]-Today() I get a perfect result in days
Now I would like to eliminate a number of records by "Suppress when Value is Null" and as expression
If([SalesDocumentConfirmedScheduleLine.Delivery date]-Today() > 0, Null())
but this doesn't -seem to work.
For alle values I get a Null()
So I probably misunderstood your problem.
The above given expression is returning correct values, limited to future dates, in my setting. Please see attached.
Regards,
Stefan
I think your expression misses the THEN part, NULL() should be the ELSE part, right?
Like:
If([SalesDocumentConfirmedScheduleLine.Delivery date]-Today() > 0, [SalesDocumentConfirmedScheduleLine.Delivery date]-Today(), Null())
Hope this helps,
Stefan
Stefan,
No, it doesn't change a thing
Thanks anyway.
Guy
Hm, should work given that at least some of your [SalesDocumentConfirmedScheduleLine.Delivery date]
values are Dates in the future (otherwise subtracting today will always be negative))
Stefan,
Correct, some dates are in the future and the standard calculation works as I already said in the first mail.
Kind regards,
Guy
So I probably misunderstood your problem.
The above given expression is returning correct values, limited to future dates, in my setting. Please see attached.
Regards,
Stefan
Stefan,
Thanks, it works now
Kind regards,
Guy