Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
hello
you should have
min({1}RatioNum/RatioNum)
the set analysis apply to the grouping function, not to each of the operands
How about this
$(vRatioDenum) = '[' & RatioDenumName & ']'
$(vRatioNum) = '[' & RatioNumName & ']',
Min({1} $(vRatioNum)/$(vRatioDenum))
Nope, does not do the trick, unfortunately.
I understand that, but it doesn't work that way
Would you be able to share a sample?
Need to think about that in order to come up with an example, since it is not straight forward. Will try to do later
Can we add this way Sunny:
= Min({1} $(=vRatioNum)/$(=vRatioDenum))
Worth giving it a shot
Doesn't evaluate to a result(