Forum Discussion

GhadaMehrez's avatar
GhadaMehrez
Icon for Helper III rankHelper III
4 years ago

Convert 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:  
Need Help
GhadaMehrez's avatar
GhadaMehrez
Icon for Helper III rankHelper III
4 years ago

Thanks a lot I followed the steps for the measure but for the aggregation function I

put Value I don't know if it the right one I just select Estimated cost field and filtered by project and created the measure but I still have the wrong percentage, any advice?

 

%ETC = VALUE( (CustomCulculations[Actuals Booked]))

 

jennratten's avatar
jennratten
Icon for Super User rankSuper User
4 years ago

Please try these:

This one for the percent value

% ETC = count(CustomCulculations[Actuals Booked])

This one for the number value

# ETC = count(CustomCulculations[Actuals Booked])