Set analysis for from to date filter not working help required.

[#1]

I'm getting list of breakdown equipment which is start date is AUSVN and End date is AUSBS field. I want to get list of equipment for the month select with variable and using set analysis. I've used following formula.

=Count({1<AUSVN = {'>=$(vMalFunStDT)<=$(vMalFunStDT)'}>} {1<AUSBS = {'>=$(vMalFunStDT)<=$(vMalFunStDT)'}>} {$<Plant= {$(vWERKS)} >}distinct EQUNR_V)

/Count({1<AUSVN = {'>=$(vMalFunStDT)<=$(vMalFunStDT)'}>} {1<AUSBS = {'>=$(vMalFunStDT)<=$(vMalFunStDT)'}>} {$<Plant= {$(vWERKS)} >}QMNUM)

where EQUNR_v is equipment and QMNUm is note no.

Find attached sample.

Thanks

Ashif

[sushil353]

Hi Try below Expression:

=Count({1<AUSVN = {">=$(vMalFunStDT) <=$(vMalFunStDT)"},AUSBS = {">=$(vMalFunStDT) <=$(vMalFunStDT)"},Plant = {'$(vWERKS)'}> Distinct EQUNR_V}/ Count({1<AUSVN = {">=$(vMalFunStDT) <=$(vMalFunStDT"},AUSBS = {">=$(vMalFunStDT) <= $(vMalFunStDT)"},Plant = {'$(vWERDS)'}>} Distinct QMNUM)

HTH

Sushil

[lironbaram · Accepted solution]

hi made some changes to your model

have a look at the expression