1 Reply Latest reply: Sep 24, 2017 4:41 PM by Stefan Wühl RSS

    Error Aggr()

    Prithvi K

      I am trying to write below in the datamodel script. and it shows error.

      Please help in correcting this.

       

      Aggr(NetWorkDays([Start],Today()),[Start]) as "Networking Days",

        • Re: Error Aggr()
          Stefan Wühl

          You can't use Aggr() function in the script, it's only available in the front end.

           

          There is not enough information to give you a good advice (in general, you would need a GROUP BY clause and aggregation functions to get something like Aggr() in the script).

           

          But maybe you just need a per record calculation:

           

          NetWorkDays([Start],Today(1)) as "Networking Days",