Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Im trying to make this expression
Load
[journalnr],
(date - regdate)/(count(items)) as average
when i reload I get invalid expression
date - regdate gives me the number of days
count items is the number af items
so what I want is number of days divided by number of items
sorry I cant attach file
thanx
Hello,
you cannot do a count() inside the script as the script take the rows one by one.
The only way to achieve what you want to do is to create a temp table with a 'group by' to calculate that count before using the information.Hope I am clear enough.
Philippe
