Forum Discussion

MeaganMcOlin's avatar
MeaganMcOlin
Qrew Cadet
2 years ago

Neep help writing a Mathmatical Formula

I have created a Formula - Numeric field for this, but I don't know how to write the formula. 
I need [Room Square Footage] divided by [Bench - Total] multiplied by [Bench - PI]. Could someone help me with this? 

Example entry:



------------------------------
Meagan McOlin
------------------------------
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    2 years ago

    If you're familiar with Excel - keep that as your default style as a starting point as a best practice. 

    To your question: 

    ([Room Square Footage] / [Bench - Total]) * [Bench - PI]

    I think that's the way you described it at least.



    ------------------------------
    Chayce Duncan
    ------------------------------
    • MeaganMcOlin's avatar
      MeaganMcOlin
      Qrew Cadet
      2 years ago

      Brillant. That worked and was much easier than expected. Thank you!!



      ------------------------------
      Meagan McOlin
      ------------------------------