locked
Need help formatting fields with percentage RRS feed

  • Question

  • 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?

    Thursday, May 10, 2012 10:59 AM

All replies

  • User-501297529 posted

    Anyone with any ideas on this?

    Thursday, May 10, 2012 1:46 PM