Forum Discussion

MeaganMcOlin's avatar
MeaganMcOlin
Qrew Trainee
6 months 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
------------------------------

2 Replies

Sort By
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    6 months 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 Trainee
      6 months ago

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



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