Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: need help building an expression that show percentage change

Results 1 to 2 of 2
Share This Thread →
  1. #1
    bigmo90 is offline Registered User
    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
    meratigoerr's Avatar
    meratigoerr is offline Contributing User
    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    58
    Change the semi-colon to a comma.

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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

ASP Free Advertisers and Affiliates