Set Analysys with date criteria's challenge

[deerhunter]

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

[sunny_talwar]

What is the format of StartDT?

[sunny_talwar]

But where is StartDT, the field you are using in set analysis?

[sunny_talwar]

But you are not using any of these in your set analysis... I am completely confused now...

[deerhunter]

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

[sunny_talwar]

I see a lot of KPI objects... which one am I looking at and what is the expected output here?

[deerhunter]

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