Min(Only()): nested aggregation not allowed

[Anonymous]

Dear all,

I have a fields called "RatioNumName" and "RatioDenumName", what I want is to find Min(RatioNumName/RatioDenumName), but ignoring the selections on RatioNumName and RatioDenumName. Eventually RatioDenumName and RatioNumName are the names of the fields, which should be computed.

I have done the following in order to test, if everything is working as expected:

$(vRatioDenum) = '{1} [' & RatioDenumName & ']'

$(vRatioNum) = '{1} [' & RatioNumName & ']',

which seems to be working correctly, but when I say that I need:

Min($(vRatioNum)/$(vRatioDenum)), then no result.

I thought further and came with following idea:

Min($(=$(vRatioNum))/$(=$(vRatioDenum))), but again - no chances.

The last, I have tried: Min(Only({1} RatioNum)/Only({1} vRatioDenum)), but I get an error that "Nested aggregation not allowed", Does anyone has any clue, where the issue is?

[olivierrobin]

hello

you should have

min({1}RatioNum/RatioNum)

the set analysis apply to the grouping function, not to each of the operands

[sunny_talwar]

How about this

$(vRatioDenum) = '[' & RatioDenumName & ']'

$(vRatioNum) = '[' & RatioNumName & ']',

Min({1} $(vRatioNum)/$(vRatioDenum))

[Anonymous]

Nope, does not do the trick, unfortunately.

[Anonymous]

I understand that, but it doesn't work that way

[sunny_talwar]

Would you be able to share a sample?

[Anonymous]

Need to think about that in order to come up with an example, since it is not straight forward. Will try to do later

[vishsaggi]

Can we add this way Sunny:

= Min({1} $(=vRatioNum)/$(=vRatioDenum))

[sunny_talwar]

Worth giving it a shot

[Anonymous]

Doesn't evaluate to a result(