percentage in dimension values in straight table?

[ioannagr]

Hello experts,

I have two questions regarding the calculation of percentage by dimension values in my straight table.

I have this dimension called "Reasons" and the values are reason1, reason2,....,reasonN.

1) total IDs that have a reason is :

count(total {<Reasons={"=len(Reasons)>0"}>}  ids)

and for percentage or each Nth reason in table I did:

 count({<Reasons={"=len(Reasons)>0"}>}  ids)/count(total {<Reasons={"=len(Reasons)>0"}>}  ids)

First of all the total in table shows 102,4% (??!?! 😂), secondly, if i pick 2 reasons the percentages DON'T sum up... 

and

2) I have another straight table with a drill-down dimension.  I did 

 count( ids)/count(total   ids)

but when i go to second level of drill down the percentages go crazy. I mean, if the first shown percentage was 10%, the second level i would expect to get divided into the subcategories, but that certainly doesn't happen...

I'm confused with what should be so simple 😫Help?