Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Firstly I have a column %complete its type is Decimal number and If i try to change its column type from "Decimal number" to "Percentage", it is converting the 100 to 1000%
100 get converted to 1000%
And second part of question is, How how do i calculate Actual quantity based on %complete
So ,
Actual Qty = PhysicalQuantity * 100%
So when 100% Actual unit = 7027 * 100% = 7027
say if the %complete is 30% then it should multiply by, 7027*30% = 2108
Solved! Go to Solution.
@Anonymous ,
Go to Add Column tab, Select math button choose Percentage. Choose 1 %. Then go to type and change to percentage. Then multiply against column 1. The last picture shows the two intermediate columns removed. You don't have to do this step, but you can see that it worked.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
@Anonymous ,
Go to Add Column tab, Select math button choose Percentage. Choose 1 %. Then go to type and change to percentage. Then multiply against column 1. The last picture shows the two intermediate columns removed. You don't have to do this step, but you can see that it worked.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
@Anonymous ,
Glad I could help!
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |