Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i am experiencing problems with the following
count({$<(inLeveransDatum -Lev_Leveranstid)> Villkor_inlev>} %InLevNr)
it seems to be a syntax error.
what i am trying to do is find the value between two dates (inLeveransDatum - Lev_Leveranstid and then do a check if they are greater than the actual condition so example 5 days 1 day or 3 days and then count the amount of i
Hi,
Try this expression
=Sum(Aggr(If((inLeveransDatum - Lev_Leveranstid)> Villkor_inlev, 1, 0), [%InLevNr]))
Regards,
Jagan.
Try like:
=Count({<Lev_Leveranstid={"=(inLeveransDatum-Lev_Leveranstid)>Villkor_inlev"}>} DISTINCT Lev_Leveranstid)
Note: DISTINCT you might or might not need.
Hi,
I am afraid that unfortunately you cannot set that calculation directly in the set analysis. You need to save it before (in a field in the script) and use the field in the set analysis expression:
inLeveransDatum -Lev_Leveranstid as NewField;
count({$<NewField= {">= Villkor_inlev"}>} %InLevNr)
Hope this helps.
Hi,
Try this expression
=Sum(Aggr(If((inLeveransDatum - Lev_Leveranstid)> Villkor_inlev, 1, 0), [%InLevNr]))
Regards,
Jagan.
Are you sure you want to do SET? there are alternative ways of solving it. I attach a solution with sum(aggr())
-sum(aggr( ($(vL.Delay)<=(inLeveransDatum-Lev_Leveranstid)),%InLevNr))
-sum(aggr( only(Villkor_inlev)<=(inLeveransDatum-Lev_Leveranstid)),%InLevNr))
Edit: Missed the Villkor_inlev.