4 Replies Latest reply on Nov 15, 2016 12:52 PM by Chris Beck

    How to recreate simple Excel calcuation

    Teresa Wright

      Can you divide one calculated field by another calculated field?  I am unable to do so (get zero result).

       

      Average Expense (calculated field) =    471,854

      Average Volume (calculated field) = 1,703,779

       

      Cannot create a calculated field to divide Average Expense by Average Volume.  I have adjusted the number format to 3 decimals, but no result.  Does anyone have an idea of how to achieve this?  it was so simple to do in Excel.