1 of 1 people found this helpful
I don't think the view that you are trying to achieve would be practical - and this is why you are having difficulties.
Because you are already viewing the dimension of deployment status - Installed, Scoped etc then trying to get a percentage of installed will either give you
100% on the installed line
or 0% on the other lines (scoped, Back Burner)
Looking at an installed percentage only makes sense if it is aggregated at another level (in this case the Account Level).
See attached workbook for example.
Hope this helps
I think you were on the right track Ian. You divided by the % of # of devices installed; I was going for % of accounts captured. I think the main thing I had wrong was trying to use 0 instead of Null in my IF statements.
Thanks this worked for me too.