Percentage Issue in If Else Condition

[waqasshah]

Hi Guys,

I am trying to calculate the percentage value if specific criteria meets. I don't know why If Else condition is not working . . The charts will be my proposed output. Please review the attached screenshots. Please help.

Kind Regards

Waqas Shah

[joseph_eftamand]

Have you tried using set analysis?

Sum({<Specialty = {'SpecialtyName'} >} SNA) / Sum({<Specialty = {'SpecialtyName'} >} Total SNA)

Let me know if that works for you.

Thanks,

Joseph

[waqasshah]

Thanks for your reply. No I have not use set Analysis before. I will try this but do you have any idea what's wrong with my script?

Surely I will try set analysis

regards

Waqas Shah

[joseph_eftamand]

The SNA field is underlined indicating QV may not recognise the field. Also what tis the field TotalSNA? 

[waqasshah]

I just change the names .. Please have a look now with your set analysis.. but no luck,,, please have a look now

[joseph_eftamand]

can you send a small sample of data to test?

[waqasshah]

I have attached sample data ..

[timpoismans]

Based on your sample data out of Excel:

On the left is the data load, on the right the percentage.

I don't understand the relation between the DNA field and DNA total though.

[waqasshah]

Thanks for your reply. Please review the updated dataset.

DNA means Did Not Attend

DNATotal =  DNA  + Attends

Like We have DNA Speciality called Surgery e.g. . we need to know in the financial year of 2017/2018 what were the percentage of patents who did not attend their clinicians. I hope it makes sense.

Kind Regards

Waqas Shah

[timpoismans]

Makes sense.

Please take a look at the image below if this is the desired result:

Loaded data is on the left.

Table on the right  gives you the percentage of DNA for that specialty in the financial year.