Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear experts,
I have a following table structure:
Ratio | Numerator_Field_Name | Denominator_Field_Name | Formula |
---|---|---|---|
Ratio 1 | Numerator 1 | Denominator 1 | |
Ratio 2 | Numerator 3 | Denominator5 |
Numerator_Field_Name and Denominator_Field_Name are the name of the columns, which should be considered, while computing formula. Just to test, I have tried the following formula:
=$('Sum(['& Numerator_Field_Name& '])'),
but the result is always '-'.
Can someone give a hint, how to achieve this? Or is there any better way to do? The formulas are basically - min, max, sum, and fractile.
Thanks.
May be try like:
= $(='Sum(['& Numerator_Field_Name& '])')