1 Reply Latest reply on Sep 27, 2018 7:45 AM by Jim Dehner

    error expression

    wiem bekir

      Hello Guys,

       

      I hope all is good.

       

      I get this error : Capture.PNG

      here is my expression :

      (IFNULL(SUM([Closing base]) - SUM ([Openning base]),0))-[Gross Addss]-[Net Migrationn]

       

      any help please.

       

      Thanks

        • 1. Re: error expression
          Jim Dehner

          Hi

          the message is telling you that   closing base and opening base are aggregate with sum() but   either or both gross adds or net migration  are not aggregated - you will need to aggregate them with sum() or other aggregating function

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.