expression issue

[sakshikaul]

Dear All, I have to write an expression for the following scenario:- I have to write a formula to get percentage for NC'S NC's/Total NC's * 100

[lironbaram · Accepted solution]

hi 

have you tried : 

(sum(NC) / sum(TOTAL NC))*100

[petter]

It should be something like this if the field is named NC: 

Sum(NC) / Sum(TOTAL NC) * 100

The level that the total should be calculated at can be explicitly specified like this if needed:

Sum(TOTAL <USERID, ClusterName> NC)