User-501297529 posted
I get errors when I try to format percentage. I've tried just about everything not sure what I'm missing. I tried it two ways the first by going into the Expression and formatting.
This is where it just says 'Error' Here is code:
=round(Fields!ContainerDiff2010vs2011Fct.Value/Fields!LastYearQtyActualContainers.Value * 100,2)& "%"
The other is when I am using this code and I right click on the textbox, go to Properties and format code and select Percentage and it says 'NaN':
=Fields!ContainerDiff2010vs2011Fct.Value/Fields!LastYearQtyActualContainers.Value
Which one should I use for formatting percentage and what is the correct code to get it to work?
