Jump to content

ltoro

Members
  • Content count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About ltoro

  • Rank
    Newbie
  1. I am creating a confirmation letter using Bi Publisher with Word Add In. I need a field to convert a varchar to number then multiply this by 75% and of course if the field is zero to equal zero. For example my room_rate is the field and currently is 3,000.00 and I need to show the net amount which is always 75% because 25% is taxes so I need it to display 2250. I have tried writing the below but it results in a '0' I apologise for my lack of skills as I am just beginning. Thanks in advance!!
×