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