Oct 12, 2009 #1 pj2256 Programmer Joined Oct 12, 2009 Messages 6 Location US My report is giving me a whole number for a person's weight. How do I format it to pounds?
Oct 12, 2009 #2 CoSpringsGuy IS-IT--Management Joined Aug 9, 2007 Messages 955 Location US does the whole number represent ounces and you need that converted? show your raw data and what you want it to look like on the report _____________________________________ Crystal Reports XI Developer Version Intersystems Cache 5.X ODBC connection Upvote 0 Downvote
does the whole number represent ounces and you need that converted? show your raw data and what you want it to look like on the report _____________________________________ Crystal Reports XI Developer Version Intersystems Cache 5.X ODBC connection
Oct 12, 2009 Thread starter #3 pj2256 Programmer Joined Oct 12, 2009 Messages 6 Location US I am getting 2,800.00 or 3,500.00 as the weight. Upvote 0 Downvote
Oct 12, 2009 1 #4 lbass Technical User Joined Feb 9, 2002 Messages 32,818 Location US You really should find out what the number represents before moving forward, but it looks like it might be ounces, so you would just use: {table.number}/16 -LB Upvote 0 Downvote
You really should find out what the number represents before moving forward, but it looks like it might be ounces, so you would just use: {table.number}/16 -LB
Oct 12, 2009 Thread starter #5 pj2256 Programmer Joined Oct 12, 2009 Messages 6 Location US I checked and it is ounces. I entered the above and got the # in pounds. Thanks for your help. Upvote 0 Downvote