none
Export scorecard to excel when % less than 1% incorrect RRS feed

  • Question

  • I'm having a problem similar to this one (which I think was fixed long ago)
    http://social.technet.microsoft.com/forums/en-US/ppsmonitoringandanalytics/thread/2be02dc6-3395-4e94-9424-23d9148afed6/

    But the problem I have is exporting percentages from a scorecard.  When the absolute value of the percentage is < 1% (e.g. -0.1%), the export in excel is incorrect.  In excel, this number (-0.1%) would looke like "-9.6%".  When I click on the value in Excel and look at the formula bar, the number is -0.096. 

    For values where absolute value >=1.0%, the export looks fine in Excel. 

    Seems like this old bug was fixed but there was a range where the fix wasn't effective?

    I just updated the PPS server to 3.0.4315.00, and the bahavior is the same as before.

    Any ideas?  Obviously this is a big problem for us...anyone found a way to solve this problem?
    Thursday, June 18, 2009 3:14 PM