5 Replies Latest reply: Feb 7, 2017 2:21 AM by Александр Закревский RSS

    Why can the partial sums in pivot chart differ from the real sum of expression?

      I've created a pivot table chart with a if-calculated expression and enabled "Show partial sums" option. The trouble is that the total sum doesn't match the real sum of the values... What can cause the trouble?

      The expression is: if($(vSpb)<sum(cf_od_sz),if($(vSpb)<sum(cf_vv_sz),$(vSpb),sum(cf_vv_sz)),($(vSpb) - sum(cf_od_sz)-$(vSpbNA)))