4 Replies Latest reply on Oct 4, 2017 7:35 AM by robin.o

    Sum and average in one table

    robin.o

      Hi all,

       

      so i'm trying to build a dashboard where i can show the average and sum of values in one table based on the value in a column called Unit.

      If it's an %, it should show the average of the values. If it's # it should show the sum of the values.

       

      I can't seem to get it to work and now i'm thinking it's not possible, but maybe one of you knows it. I'm using 10.3

       

      So this should be my goal:

       

      Code
      UnitValue
      AA-001%23,8
      AA-002%23,1
      AA-003#20
      AA-004%10,8
      AB-001#10
      AB-002#12

       

      I tried it with a formula, but it still shows the sum:

      IF [UNIT] = "#" THEN

      [REALISATION]

      ELSE

      [AANTAL]/[REALISATION]

      END