15 Replies Latest reply: Sep 26, 2014 1:49 PM by Stefan Kunte RSS

    how to calculate total while populating null as '-' in the expressions.

      Hi,

       

      I have list of values which are missing or not present in database but is needed to be shown in the report as '-' (hyphen).

      At the same time, need to calculate the total for those expression. But the total is not displaying correctly.

      My expression uses : Value: aggr(sum(value),entity1,entity2) and Amount: aggr(sum(amount),entity1,entity2)

      aggr has been added to show hyphen(-) for missing or null values.


      for eg:

      Expected Result

      Entity1
      Entity2ValueAmount
      aaa-20
      aab1040
      aac20-
      total3060

      Actual Result

      Entity 1Entity 2ValueAmount
      aaa-20
      aab1040
      aac20-
      total--

       

       

      Any help would be great!!