#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Dec 2012
    Posts
    1
    Rep Power
    0

    need help building an expression that show percentage change


    hi im trying to build a expression that shows percentage change this is what i have put

    MonthlyPercentageChangeofSweetPotatoesfrom1994-2012: Format(([Datavalue]/[Previousvalue])-1;"Percent")

    I am able to get it to show the percentage values but it shows as a text not a number. I wanted it to be a number value as a displayed as a percent instead please help
  2. #2
  3. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    59
    Change the semi-colon to a comma.

Similar Threads

  1. Empire State Building IPO change may help pay tax
    By RSS_News_User in forum Business News
    Replies: 0
    Last Post: May 8th, 2012, 11:00 PM
  2. Leaders say momentum building on climate change (AP)
    By RSS_News_User in forum Science News
    Replies: 0
    Last Post: November 28th, 2009, 04:03 PM
  3. Building a Java Expression Tree; PLEASE HELP
    By strakerc in forum Programming Help
    Replies: 0
    Last Post: June 23rd, 2008, 08:07 PM
  4. Expression to get a percentage
    By jenna in forum Microsoft Access Help
    Replies: 2
    Last Post: January 22nd, 2005, 02:31 PM
  5. Creating expression to find a percentage
    By jenna in forum Microsoft Access Help
    Replies: 2
    Last Post: January 21st, 2005, 08:25 AM

IMN logo majestic logo threadwatch logo seochat tools logo