5 Replies Latest reply on Nov 29, 2018 11:22 PM by Ivana Pavlova

    Tableau calculation field - wrong totals

    Ivana Pavlova

      Hello Tableau users,


      I am experiencing the following problem with the calculation fields in Tableau. In the data example below, we would like to know what is the % of autosettled items for Mr.Renannt for the all periods (from weke 38 to week 47 incl). The % autosettled field is calculated as:

      (Manual/(Manual+Automatic)). Tableau gives accurate results on line items (per week), but the total % (0.34 in the example below) is not correct calculation. It should be 17/47, or 0.36.


      Thanks a lot for your help on this one,


      Have a nice day


      Message was edited by: Ivana Pavlova