Jump to content

kbqwert

Members
  • Posts

    3
  • Joined

  • Last visited

Posts posted by kbqwert

  1. I am extracting data from 2 fields, rs(“markup”)  is a numeric fieldAnd rs(“cost”) is a currency field.I need to use rs(“markup”)  to get a Percentage of rs(“cost”) then add that Percentage to rs(“cost”), then deliver the total as currency.I have tried using FormatPercent, but this delivers un-expected amounts (perhaps due to the decimal point in the currency field??) and delivers the result with a % on the end. :) Can anybody suggest a way of doing this?

    TRY THIS:<%Dim TotalCostTotalCost = FormatCurrency(((rs(“markup”) / 100) * rs(“cost”)) + rs(“cost”))Response.Write TotalCost%>
×
×
  • Create New...