Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I need help in writing an expression in text box as if max(MY) is present in the Field then print the message as present or absent . Not sure how to achieve it. Attaching the sample application.
May be this:
=If(SubStringCount(Concat(Filename),$(vMonthId)) > 0 ,1, 0)
Changed the variable to this: Max(Num#(MY, '##'))
May be this:
=If(SubStringCount(Concat(Filename),$(vMonthId)) > 0 ,1, 0)
Changed the variable to this: Max(Num#(MY, '##'))
try like this?
Take a variable, say:
Let VMax=max(FieldName);
Then in Text Box try this?
If(FieldName='$(VMax)', 'Present', 'Absent')