Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008
    Posts
    2

    Unanswered: AS2005 Format String syntax

    I'm new here so I'm not sure if this is the correct spot to post this question but here goes.

    In the cube design view under the Calculations tab I have several calculated members that I have created. Each of these are dollar amount fields for which I have defined a Format String property as follows:

    Format String: "$#,##0;($#,##0);;\N\/\A"

    This format correctly handles my positive value, Negative value and my NULL value the way I want. However I need to deloy this cube on one of my UK severs and I don't want the $ but instead I would like the pound sign without having to recreate this entire project to do so. I have tried the following syntax but it is incorrect.

    Format String "Currency;;;\N\/\A"

    Can someone help me with the correct way to code the property so that I can get my currecy symbol based on the regional setting as well as handle my NULL values.

    Thanks

  2. #2
    Join Date
    May 2008
    Posts
    2
    Lots of lookers but no answers. Is the question not clear or just one without an answer? Anyway if anyone has a suggested solution Im open.
    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •