Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have the following set analysys statements that return the same results?
Return a count where start date + 30 is = or greater then finish date:
Count ([WNUMBER]) - Count({< StartDT =
{">=$(=num(date#(StartDT +30)) =>num(date#(FinishDT)))"} >} [WNUMBER])
Return a count where start date + 30 is = or less then finish date:
Count ([WNUMBER]) - Count({< StartDT =
{">=$(=num(date#(StartDT +30)) =<num(date#(FinishDT)))"} >} [WNUMBER])
Can anyone see why?
Also, if i want to add additional criteria like: ,status={'C','P','A'}
Thanks in advance
What is the format of StartDT?
But where is StartDT, the field you are using in set analysis?
But you are not using any of these in your set analysis... I am completely confused now...
< 30 Days:
Count({< actstart = {">=$(num(actstart + 30,'###0') =<actfinish)"},worktype-={'PM','OC'} >} [wonum measure])
> 30 Days:
Count({< actstart = {">=$(num(actstart + 30,'###0') =>(actfinish))"},worktype-={'PM','OC'} >} [wonum measure])
Sunny here is a limited load qvf.
I see a lot of KPI objects... which one am I looking at and what is the expected output here?
mainly the two on the right, (< 30 days --> actstart/actfinish) & (> 30 days --> actstart/actfinish).
Correcting those will help me see the error and correct the ones on the left to include your updates.
Thanks Sunny your a big help