set analysis not getting filtered????

[#1]

Hello ,

In my database I have a table with following data

primary_key  partners  invoiced_status     registration_status  cancellation_status

1                    abc           invoiced                     registered                cancelled

2                    xyz           not_invoiced               not_registered          not_cancelled

3                    pqr            not_invoiced               failed                      cancelled     

4                    cde           invoiced                      registered                cancelled

5                 abc	invoiced	registered	cancelled
6                xyz	invoiced	registered	not_cancelled
7                pqr	invoiced	failed	cancelled

I have created a straight table which contains data like given below:

partners  registration_rate registerd_count unregistered_count

abc             95%                     460                         20

xyz              65%                     340                         30

pqr               58%                     120                         15

The formula that I have used for calculation are  given below

registered_count  //number of product which are registered and not cancelled

Count ({<[registration_status]={'REGISTD'},cancellation_status ={not_cancelled}>}[primary_key])

registration_rate   //  (num of product registered and not cancelled/ number product invoiced and not cancelled)*100

round((count({$<[invoiced_status]={'INVOICED'},[registration_status]={'REGISTD'},cancellation_status ={not_cancelled}} [primary_key])

/count({$<[invoiced_status]={'INVOICED'},cancellation_status ={0},[Invoice Date] = {'>=$(=v12MonthsBack)<=$(=v90DaysBack)'}>} [primary_key]))*100,0.01)

unregistered count

registered_count

Count ({<[registration_status]={'REGISTD'},cancellation_status ={cancelled}>}[primary_key])

Registration_status
Registered
failed
not_registered

.Even if user selects failed or not_registered from the list box.

the below formula shows only registered count.

the set analysis formula is not getting filtered ..I am not understanding why it is not getting filtered?..

registered_count

Count ({<[registration_status]={'REGISTD'},cancellation_status ={not_cancelled}>}[primary_key])

[sasiparupudi1]

shouldnt it be  ? your table shows the string in lower case

Count ({<[registration_status]={'registered'},cancellation_status ={not_cancelled}>}[primary_key])

and it will always show the count for only registered values irrespective of the selection..

Is it what you wnat to achieve?

[ChiragPradhan]

Because your set analysis expression is filtering on "REGISTD" registration status only.

Regards

Chirag

[#4]

No. I want the count to be calculated according to the filter. So when I select registration status as failed. The registered_count should be null.

[sasiparupudi1]

I say, remove the filter in your set analyis for registration status

Count ({<[registration_status]={'REGISTD'}, cancellation_status ={not_cancelled}>}[primary_key])

[Anonymous]

hi divya,

unregistered count:

Count ({<[registration_status]={'not_registered'},cancellation_status ={'not_cancelled'}>}[primary_key])

[ellenblackwell]

In your example, your cancellation_status parameter is not in single quotations.