Forum Discussion
Solved
Help with a percentage column
Hi All, Any help here gratefully received. I have a table which has a column with property names, a column with tenant names, a column with charge types, a column with dates, then columns with am...
Hello! What do you currently have for your measures? You can try the following:
Total Amount Charged = SUM('YourTable'[YourField_Charged])
Total Amount Received = SUM('YourTable'[YourField_Received])
Total Percentage Received = DIVIDE([Total Amount Received],[Total Amount Charged]
audreygerred
Super User
Super UserHello! What do you currently have for your measures? You can try the following:
Total Amount Charged = SUM('YourTable'[YourField_Charged])
Total Amount Received = SUM('YourTable'[YourField_Received])
Total Percentage Received = DIVIDE([Total Amount Received],[Total Amount Charged]
Thank you! I was trying things far more complicated than that!
- audreygerred
You are very welcome!
