Getting field name from column and performing calculations
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.