5 Replies Latest reply: Mar 6, 2018 7:47 AM by Beck Bakytbek RSS

    Nullvalue in Aggr

    Beck Bakytbek

      Hi Folks,

       

      i have a question:

       

      my table does look like:

       

                         Budget               Invoice                     Sum                              Duduction ( 0,5 * Sum)

       

      Sum            212816               242131,24               = -  29135,24                           0

       

              Pos1   212816                  0

              Pos2      0                       211530,387                 1285,62                              642,81                       

              Pos3      0                        30600,86                     0

       

       

      i am using the aggr-funct : Sum(aggr(if(Budget - Invoice <0, 0, Budget-Invoice)),MyDimension) it does work great,

      but the Amount: 1282,62  (1282,62 * 0,5 = 642,81) will take into account.

       

      how can i handle if my total Sum = 0, so then complete Deduction should have no values.

       

      does anybody have any ideas?

       

      Thanks a lot

      Beck