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.
