Forum Discussion
icdns
5 years agoPost Patron
Calculate Percentage
Hello,
I want to calculate and find what is the percentage of the Paperless Bills among the Non Paperless Bills
I have a 2 measures that counts the paperless and non paperless. What can be my formula?
Thank you
you can try by creating a measure and format it as Percent.
_Percent = FORMAT( DIVIDE ([counts of paperless],[count of non paperless],BLANK()) ,"Percent")
1 Reply
- FarhanAhmedCommunity Champion
you can try by creating a measure and format it as Percent.
_Percent = FORMAT( DIVIDE ([counts of paperless],[count of non paperless],BLANK()) ,"Percent")