0 Replies Latest reply on Jan 30, 2012 7:50 AM by Gregg Thomas

    calculating %'s in financial statements

    Gregg Thomas

      i am trying to calculate %'s in a financial statement.  The tricky part is, the denominator changes depending on what expense line is being calculated.  So, Food costs would be calculated taking total food costs / FOOD Sales.  But Hourly labor would be calculated by taking total hourly labor / TOTAL Sales.

       

      I'm having a hard time getting tableau to decipher between food sales and total sales.  Can anyone help?

       

      Thanks!!