Select the minimum value (set analysis)

[#1]

Hello,

In this example, my set analysis works if I do the set analysis based on the ID field.

But why does that not work based on the "Gewicht" field ? Both fields are numeric data.

Do you have an idea ? Thank you!

[swuehl · Accepted solution]

Is your expected result 340?

Try enclosing the dollar sign expansion in the set modifier element list with single quotes:

=sum({$<[Gewicht.]={'$(=min([Gewicht.], 1))'}>} ZE_value)

I think the percentage format of your field is confusing QV here.

Hope this helps,

Stefan

[#3]

Yes it was the problem thank you. I've also found a solution meanwhile, where I've created a second field in my script, that was: Gewicht * 100 ==> this gives only 10 and not 10%...

In this case the original expression works well... but your solution is by far the best! Thank you so much,

Ivan