Back again with another question. In my app, I've a screen where I want the app to display the max value of a field found in two collections (Collection1 and Collection2). 

This is one version of an attempted string, with no results:

Max(Collection1!Health, Collection2!health)

And I've also attempted to use the value function to convert the data to a number:

Max(Value(Collection1!Health, Collection2!health))

Thanks in advance for helping!

If you want to show both max value in one label use this:

Max(Collection1, Health) & " " & Max(Collection2, health)

in text option of that label

However if you want to show one max value from both collection use this:

Max(Max(Collection1, Health) , Max(Collection2, health))

• Edited by ptr.chovan 11 hours 44 minutes ago
• Proposed as answer by Lisa Chen1226Microsoft contingent staff, Moderator 25 minutes ago
• Marked as answer by Lisa Chen1226Microsoft contingent staff, Moderator 24 minutes ago

Hi caseH,

Per my test, Ptr.chovan's answer is right. 

I will mark it as an answer.

Best Regards,

Lisa Chen