1 Reply Latest reply on Aug 29, 2016 3:27 PM by Stoyko Kostov

    Group by

    Govind Ramchetty

      HI

      In Calculated field is it possible to give "Group by"

      Like below

       

      {fixed:sum(IIF([Act Start Date]>=[From Date] and

      [Act Start Date]<=[To Date],[Total],0))} group by [Description3 (copy)]

       

      It showing error.

       

      What is the syntax.

       

      Thanks

      Govind R

        • 1. Re: Group by
          Stoyko Kostov

          Hi Govind,

           

          "GROUP BY" is not a valid syntax in calculated fields. You could specify the fields you want to group by as a list in your LOD expression, like this:

           

          {fixed [Description3 (copy)] :sum(IIF([Act Start Date]>=[From Date] and [Act Start Date]<=[To Date],[Total],0))}

           

          This will make sure your calculation is first partitioned by Description 3 (copy), and then summed on each partition, regardless of what other dimensions you have in your pane (the role of FIXED).

           

          Let me know if this answers your question.