AnsweredAssumed Answered

Calculation choice from one of two fields

Question asked by rmueller@mytheatredna.com on Feb 6, 2018
Latest reply on Feb 6, 2018 by philmodjunk

Hello --

I'm looking to have a formula that if there is a specific Unit Cost that it calculates the Total Cost as Unit Cost * Quantity

 

BUT - If the Unit Cost is empty I want the formula to calculate from an Estimated Cost field * Quantity.

 

I've tried the IF and EMPTY commands, but I'm obviously doing something wrong...

 

Any help would be greatly appreciated.

 

Ryan

Outcomes