expression builder

[guymason]

I am writing a macro that includes a calculation to work out the percentage of jobs completed in x days and below. So if X days (ie 4)is chosen out of a possibility of 1 to 10, then all days beneath it (ie 3,2 ,1) must also be included. I am having trouble doing this using the 'expression builder'.
So far I am able to build an expression that works out individual days (=100/total number of jobs*jobs on that day), but am not able to include all the days below.
Is the 'expression builder' capable of using building expressions that include things like 'repeat', 'until',x=-1 etc.

Am i making any sense?

Thanks
Guy

 

[JamesMeadlock]

What you want is clear enough, but I have no idea what kind've data you're working with... I'm making assumptions here, let me know if I 'missed the ball'.

If it looks like this,

Job DaystoComplete
1 1
2 3
3 4

You could make two expressions,

Expr1: 1 (This'll count total jobs)
Expr2: (Iff(DaystoComplete <= 4,1,0) (This'll count jobs completed within 4 days)

and you could use the results to get the number you want.

Alternatively, you could code the whole thing. Let me know if you need more help.