I am trying to lookup a formula written as text in a parent table and convert it to an actual numeric formula field in a child table.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Jarrod

Jarrod

  • 0 Points

Posted 3 years ago

  • 0
  • 1
It's really not possible to do that.  But I'm sure that there is a way to accomplish your needs another way if you can explain your objective.
Photo of Jarrod

Jarrod

  • 0 Points
I am writing an estimating tool that has various electric rates and monthly bills.  The rates have similar structures rate to rate, but the way they are calculated are different. I wanted to use the rates (Rates have many Bills) as the parent and lookup the formula to calculate the bill.
You do not need to carry down the actual formula to use.  You just to carry down the information about WHICH rate formula to use.

So come up with a multiple choice field on the parent rates table and look that up down to Bills.

Then use an IF statement or a Case statement to calculate the amount.

For example

Case([Rate Plan],
"A", then out your formula here,
"B", then out your next formula here,
"C", then out your other formula here,)