Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have this expression =Count({<LateDisp={'$(v1dayLate)'}, OrdStat={'CONFIRM'},InternalServPfeYn={'N'},InternalServExternalPi={'N'}>}DISTINCT if(FinUnits<OrdUnits, ItemOrd)).
I wanted to use the set identifier "1" only for the first condition LateDisp={'$(v1dayLate)'}. Is that possible? How?
Thank you!
Sofia Vaz
What does this variable? v1dayLate. May be this?
=Count({<LateDisp={"=Only({1} $(v1dayLate))"}, OrdStat={'CONFIRM'},InternalServPfeYn={'N'},InternalServExternalPi={'N'}>}DISTINCT if(FinUnits<OrdUnits, ItemOrd))
I think this should work for you:
=Count({1<LateDisp={'$(v1dayLate)'}> * <OrdStat={'CONFIRM'},InternalServPfeYn={'N'},InternalServExternalPi={'N'}>}DISTINCT if(FinUnits<OrdUnits, ItemOrd))
v1dayLate is a date. Thank you for the help but it's not working...
Thank you Petter, but it didn't work...