Forum Discussion
Helper IIIConvert field into percentage
Super UserPlease try these:
This one for the percent value
% ETC = count(CustomCulculations[Actuals Booked])This one for the number value
# ETC = count(CustomCulculations[Actuals Booked])
Helper IIIsomething is wrong here:
- jennratten
Try this one instead: count(Portfolios[pum_Name])
- GhadaMehrez
???? this not the intended feild (actuals Booked) to convert currency into %
- jennratten
Okay, 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.
- GhadaMehrez
sum 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])