
Announcements
Im starting with a comma delimited label.
I take that label and put it through a ForAll loop, using the split function.
For each value I do a conditional and it spits out a number..
This works great in a drop down control.
My end goal is to take the above at get the minimum calculated value and put that into a different label.
The Forall command fails as it expect a text string
The Min command expects a value,
The Value command to change the string to a number doesnt work.
What am I doing wrong?
resolved....
Min(
ForAll(
Split('Label Control'.Text, ", "),
If( CountIf('List'.AllItems, Result in 'Area'.Value) * (10/3) >= 10,
Value(10),
Value(CountIf('List'.AllItems, Result in 'Area'.Value) * (10/3))
)
),Value)