1 Reply Latest reply on Dec 5, 2012 9:10 AM by James Baker

    Inaccurate percentage results

    Brion Henes

      Tableau is returning an incorrect percentage calculation based on the formula below.

       

      Monthly Fee=320817

      Gross Pay - Month=174735

       

      Should be=46%

      Tableau says=52%

       

      (SUM([FACS Monthly Collections$].[Monthly Fee]) - SUM([Collector Master$].[Gross Pay - Month]))

      / SUM([FACS Monthly Collections$].[Monthly Fee])