Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have read various post but to no avail and wondered if anyone could help please.
I have the below expression:
Count({<'Document Status'={'30'},'Document Version'={'0'},'Return Due Date'={'<>Null()'}>}distinct([%Key_DIR]))
i would like to add another criteria where
([MB51.ReportDate]-[Return Due Date])<0
Thanks
Perhaps this?
Count({<'Document Status'={'30'},'Document Version'={'0'},'Return Due Date'={"=(Len([Return Due Date])<0 or <>Null()) and ([MB51.ReportDate]-[Return Due Date])<0"}>}distinct([%Key_DIR]))
Hi Anil,
Thank you for the reply but unfortunately it wrongly returned a value of zero.
The logic i am looking for is
If Document status =30
AND
Document Version=0
AND
Return Due date <>Null
AND
(MB51.Report - Return Due Date) <0
then count the unique values from ([%Key_DIR]
It works, with the exception of (MB51.Report - Return Due Date) <0 and i do not know how to add a subtraction.
Thanks