Needed help in an expression

[ferha_jafri]

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.

[sunny_talwar · Accepted solution]

May be this:

=If(SubStringCount(Concat(Filename),$(vMonthId)) > 0 ,1, 0)

Changed the variable to this: Max(Num#(MY, '##'))

[Anonymous]

try like this?

Take a variable, say:

Let VMax=max(FieldName);

Then in Text Box try this?

If(FieldName='$(VMax)', 'Present', 'Absent')