Forum Discussion
ewill_bdg
9 years agoRegular Visitor
Add Row Percentage
I need to add a colomn Matrix that calculate the percentage (%) of UNITs "ON MOVE": I almost got it, the problem is that it calculate it for all the columns. How Can I Calculate the ...
kjsullivan
9 years agoFrequent Visitor
ewill_bdg You can create a measure, such as Measure = DIVIDE([ON MOVE],[Total Sum of Available]) then convert it to a % format by clicking the measure in the Fields list then going to the Modeling tab in the top left.
ewill_bdg
9 years agoRegular Visitor
ERROR:
The value for 'ON MOVE' cannot be determined. Either 'ON MOVE' doesn't exist, or there is no current row for a column named 'ON MOVE'
Same for: Total Sum of Available