0
Using a elect with a sum in a formula slowing down.
I have a formula in a view which is slowing down the presemtationm of the view.
let xTM := Termijnnummer;
let xProject := Project;
let xTask := Werkzaamheden;
sum((select TMN where Termijnnummer < xTM and Project = xProject and Werkzaamheden = xTask).Aantal)
It is the sombination of the filter and the sum i believe. Is there a workaround for this.
Greetings Frits
3 replies
-
if you are on web vrson then add
do as server as first instruction.
this will speed things up (depending on how much data is goien back and forth)
-
ie
do as server
select JobDockets
endi'm pulling over 20,000 records on this bale and it is near instant!
-
doh - that should say table not bale!
Content aside
- 3 yrs agoLast active
- 3Replies
- 126Views