Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 formulas:
vNumeratorField = '[' & Only({1} NumeratorNames) & ']'
vDenominatorFiels= '[' & Only({1} DenominatorNames) & ']'
I need them, to find out which fields, I have to use in order to calculate the defined ratio. The typical output is following:
KPI_Name | Numerator Field Name | Denominator Field Name | Min | Header 5 |
---|---|---|---|---|
Ratio1 | =$(vNumeratorField) | =$(vDenominatorField) | ||
I am trying to find out the minimum and the maximum values doing the following for minimum:
=Min($(=$(vNumeratorField))/$(=$(vDenominatorField)))
And the same logic for maximum, but I always get '-'.
I tried to do the minimum without variables and it works perfectly: Min([FIELD1]/[FIELD2]).
Can someone advice, what should be done in other way? The issue is that I need to always ignore selections on NumeratorNames and DenominatorNames fields. That's why I am using variables and Only()
Hi,
try this:
Min( {<NumeratorNames,DenominatorNames>} [FIELD1]/[FIELD2])
Hi,
you surely have a nested agregation (because of only)
try with :
min (aggr($(vNumeratorField)/$(vDenominatorField), your dimension))
regards
Thanks for the suggestion, but it doesn't do the trick (
that gives what ?
null ?
to select all
min({1}aggr( .......)
The output is always '-' and same applies to min({1} aggr(....)). When I try to use:
=Aggr($(vNumeratorField)/$(vDenominatorField),KPI_Name),
then I see the names for the right fields, but the division '/' sign gets dissapeared and the selection is, obviously, not ignored.
aggr does not pally to kpi_name but :
min (aggr(only({1} NumeratorField,NumeratorField)) / ......
it becomes complicated,
why not :
min({1} NumeratorField/NumeratorField))
without using only ?