Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
qvqfqlik
Creator
Creator

Error Aggr()

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",

1 Reply
swuehl
MVP
MVP

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",