Forum Discussion
GhadaMehrez
Helper III
Helper IIIConvert field into percentage
I need to convert field value into percentage but when I choose to show value as a percentage I got all values as 100% which is not right:
jennratten
Super User
Super UserOkay, I took that from your screenshot. The table and column name need to appear inside the parenthesis. Also, since it is currency you are wanting to convert, I recommend you do not use count as the aggregation function. Without seeing your data and model it's difficult to say which aggregation function will be best, but you can try using sum instead of count, so sum(TableName[ColumnName]). Be sure to replace the table name and column name with the actual values from your model.
GhadaMehrezHelper III
Helper IIIsum aggregation not works
- jennratten
What is the result vs. the expected result? Can you add some snips of your data and model?
- GhadaMehrez
I hope this help:
% Actuals Booked = VALUE(CustomCulculations[Actuals Booked])% ETC = VALUE(CustomCulculations[Estimated Total Cost])