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