topic Re: Min-Function not working as expected in App Development

Min-Function not working as expected

paperjam — Mon, 17 Feb 2025 14:59:12 GMT

I would like to get the minimum between a variable (vAnzTage) and a column (Zahlungstag_Max). However, the formula Min() is not working as epected - I get always the max resp. probably one Number is not taken into account

Example: For Kampagnennummer 6640 I have Num(Zahlungstax_Max) = 4 (column). Then I have vAnzTage = 11 (variable). With Min(Num(vAnzTage), Num(Zahlungstag_Max)) I expect 4 - but I get 11. Why? Doesn't make any sense to me...

Thanks for any help!! I'm totally lost and confused....

Re: Min-Function not working as expected

Or — Mon, 17 Feb 2025 15:00:10 GMT

You seem to be confusing Min() with RangeMin(). Try the latter.

Re: Min-Function not working as expected

paperjam — Mon, 17 Feb 2025 15:19:08 GMT

Thank you Or. This works as a new calculated measure perfectly. However, then I have the following question:
I want to filter for this RangeMin Logic - now the maximum is taken again...

My formula:

Sum(

Kampagnennummer,

Zahlungstag = {$(=RangeMin(vAnzTage, Zahlungstag_Max))}

KampagneBetragKumuliert)

What I expect for the first line:

Sum(

Kampagnennummer,

Zahlungstag = {4}

KampagneBetragKumuliert)

What I get:

Sum(

Kampagnennummer,

Zahlungstag = {19}

KampagneBetragKumuliert)

I guess Zahlungstag_Max is taken from the total. How to filter only for the row (Kampagnennummer)? Something with AGGR()?

Re: Min-Function not working as expected

Or — Mon, 17 Feb 2025 15:24:07 GMT

I didn't quite follow the logic in your post. However, generally speaking:

Min() is an aggregation function. It checks records across any given number of dimensions (0..n) based on either the object it's in, or the aggr() function it's wrapped in, and returns the minimum numeric value among those values.

RangeMin() is not an aggregation function. It receives one or more numbers and returns the lowest number among those values.

I would suggest looking up both the aggregation scope documentation (or hic's posts on the subject) and dollar sign expansion documentation / posts to get a better idea of what putting these things in a set analysis might mean.