Hello,
I have a form with a table with columns like below:
In some cases, these columns are populated via a lookup rule (bottom row). In others, the mileage rate and amount due columns are not populated. When they're not populated, I'd like to have the Amount Due column multiply the Quantity column by the Mileage Rate column. That way, the user only has to enter the mileage rate, and then the Amount Due will calculate for them.
Is there a 'safe' way to do that so that this only runs on the rows I want it to? It *should* still always result in the same number, but I don't want to run into any conflicts with the lookup rule and the calculation both being performed.
Thanks!