Jump to content

Calculations on the web


This topic is 8737 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello all,

I need some help getting my web database to calculate and show the total. I have detailed the setup below in hopes that may help you help me.

First calculation field is a text field with a value list and no additional text:

$345

$395

$695

$0

Second fields are identical in text format, no text:

$45

$45

The calculation field needs to show the total. This is the calculation that worked the last time:

"TextToNum(Early Registration Fee) + TextToNum(East Additional Tickets) + TextToNum(West Additional Tickets)", with the fields respective to the above order.

This field is then used in an encryption code to be sent via a secure secondary server to a credit card site.

If anyone knows how to make this field show the calculation on the web, I would be forever grateful! At least until the next problem pops up smile.gif!!!

ldelappe

Link to comment
Share on other sites

  • 2 weeks later...
  • 1 month later...

The problem is that the text fields all contain the "$" character. You'll need to remove the "$" before the TextToNum function will work properly. Try this...

TextToNum(Subs(Early Registration Fee; "$"; "") + ...

I have used the Subs() function here, but Left() could have also been used, but would neeed to assume that the "$" is always typed.

Link to comment
Share on other sites

This topic is 8737 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.