Help with Calculations

[PrimoQuest]

Does anyone here have any detailed instructions on how to create calculations?

I tried doing some calcs, but not sure how to make it work when I run the software.
All it shows are the table names (at the top) , but no place to input calculations from the user's standpoint.

Simple example:

I need to multiply quantity and price then calculate the results.

Sounds simple, right? Easy to do on Excel, but not so much when you aren't experienced in writing software.

Any step-by-steps on doing this simple calculation would be great.

Still waiting for one of you champion software developers to create some tutorials. I'd be willing to pay decent payola for this. I'm sure others here would as well.

I do like the vids Jonathan has already created, but they show what the software features and pieces are and don't go into step-by-step detail on how to put everything together.

Thanks!

[TigerSoftware]

Does anyone here have any detailed instructions on how to create calculations?

I tried doing some calcs, but not sure how to make it work when I run the software.
All it shows are the table names (at the top) , but no place to input calculations from the user's standpoint.

Simple example:

I need to multiply quantity and price then calculate the results.

Sounds simple, right? Easy to do on Excel, but not so much when you aren't experienced in writing software.

Any step-by-steps on doing this simple calculation would be great.

Still waiting for one of you champion software developers to create some tutorials. I'd be willing to pay decent payola for this. I'm sure others here would as well.

I do like the vids Jonathan has already created, but they show what the software features and pieces are and don't go into step-by-step detail on how to put everything together.

Thanks!


Easy one. :)

Create a regular Currency Editor called "Price" and a Numeric Editor and call it "Quantity" without the quotes.

Now go to the Calculations and create a new one and call it "Results".

There will be a list of items in the Expression Builder list box. Click the Property Editors and you will see both of your editors in that list. Double click the "Quantity" editor and you will see it appear in the Expression.

You can then either type on the "*" for multiply or click on the Math Functions within the Expression Builder. If you use the Expression Builder than double click the Multiply and the multiplication symbol will appear in the Expression.

Click back on the Property Editors within the Expression Builder and double click the "Price" editor to add that to the Expression builder.

Now you should have Quantity*Price within the Expression Builder. You can edit the Express and add spaces to make it look more readable. I normally make it look like Quantity * Price.

Save and close. You are done with your first calculation.



Thomas

[PrimoQuest]

Excellent.

Thanks Thomas. I'll give it a try.

[pete]

Oh I don't think I saw this in the manual.

Is creation of calculators a feature of TSB Express or some other version. I was getting the feeling I bought a tool to make simple database apps but was hoping it would actually perform calculations too.

Sorry I'm a little confused what I bought and what other versions are available and can't find that explained anywhere either.

[TigerSoftware]

Oh I don't think I saw this in the manual.

Is creation of calculators a feature of TSB Express or some other version. I was getting the feeling I bought a tool to make simple database apps but was hoping it would actually perform calculations too.

Sorry I'm a little confused what I bought and what other versions are available and can't find that explained anywhere either.

Hi Pete,

It isn't in the manual because I just added it to the Express a couple of weeks ago. :)

I will be doing an update as well as the Pro manual once I finish up a few things. Good news is the importing is done and working. It will be in the next update.



Thomas

[pete]

How do I create a calculation that is the product of 2 other calculations? Can we only use editors in the calculations?

[jonathon]

How do I create a calculation that is the product of 2 other calculations? Can we only use editors in the calculations?
You can certainly create your own calculations. If you want the sum of 2 previous calculations, you would simply enter in both those calculations into one "property" and use the PPMDAS order of operations...

PPMDAS: Pretty Please My Dear Aunt Sally
Mnemonic for mathematics order of operation: Parentheses Powers Multiplication Division Addition Subtraction

In other words, enter your first calculation in the first set of parentheses and the second calculation in the second set with a + in the middle of the 2 sets of calculations...

Does that help? Or did I simply confuse you further or did I perhaps misunderstand the question all together?

[pete]

That helps. Thanks.

[MikeM]

((x+y)-(z+a))

[fortesque]

Hey Guys
Great posts! Really very helpful stuff.
JwB

[jonathon]

((x+y)-(z+a))
Hey Mike,

((x+y)-(z+a)+(n(s-t))+(d*f))

mine is biiiger than yoooours, so there :p

Sorry Mike, I just couldn't resist... :D

[MikeM]

((x+y)-(z+a)+(n(s-t))+(d*f))

Wow I think you got the right amount of ( ) as well :)

Gets confusing after a while

[TigerSoftware]

Hey Mike,

((x+y)-(z+a)+(n(s-t))+(d*f))

mine is biiiger than yoooours, so there :p

Sorry Mike, I just couldn't resist... :D

Is that the formula for Sam Adams Beer?


Thomas

[rrd257r]

I'm having a bit of trouble with text calculations. How would I get "TextOneEditor" to combine with "TextTwoEditor"?

For example:
If someone were to fill in both a "First Name" and a "Last Name" field, how would I type the calculation so that it automatically fills in the "Full Name" field?

[jonathon]

Is that the formula for Sam Adams Beer?


Thomas
No, SA's formula includes 3 hops and 2 skips as well (heheh, get it, HOPS, HAHAHAH - ok, I'm done now, heheh)...

[jonathon]

I'm having a bit of trouble with text calculations. How would I get "TextOneEditor" to combine with "TextTwoEditor"?

For example:
If someone were to fill in both a "First Name" and a "Last Name" field, how would I type the calculation so that it automatically fills in the "Full Name" field?I believe the calculations fields are strictly for numeric calculations. (I could be wrong, but I have tried it on several occasions and always receive errors...)

[TigerSoftware]

I'm having a bit of trouble with text calculations. How would I get "TextOneEditor" to combine with "TextTwoEditor"?

For example:
If someone were to fill in both a "First Name" and a "Last Name" field, how would I type the calculation so that it automatically fills in the "Full Name" field?

Try

textfield + " " + textfield


Thomas

[jonathon]

Try

textfield + " " + textfield


ThomasI have tried that, as well as many other various algorithms, and it always errors

[jonathon]

Hey T, i know you're busy but any word on this?

[TigerSoftware]

Hey T, i know you're busy but any word on this?

On what? The Text fields?

I think it is the " " that is giving the error. You can try TextField + """ """ + TextField

I haven't tested it yet.



Thomas

[daveraf]

Easy one. :)

Create a regular Currency Editor called "Price" and a Numeric Editor and call it "Quantity" without the quotes.

Now go to the Calculations and create a new one and call it "Results".

There will be a list of items in the Expression Builder list box. Click the Property Editors and you will see both of your editors in that list. Double click the "Quantity" editor and you will see it appear in the Expression.

You can then either type on the "*" for multiply or click on the Math Functions within the Expression Builder. If you use the Expression Builder than double click the Multiply and the multiplication symbol will appear in the Expression.

Click back on the Property Editors within the Expression Builder and double click the "Price" editor to add that to the Expression builder.

Now you should have Quantity*Price within the Expression Builder. You can edit the Express and add spaces to make it look more readable. I normally make it look like Quantity * Price.

Save and close. You are done with your first calculation.



Thomas

Hi I tried what was written and it worked (which was good as previously I couldn't getCalcs to work)

BUT when I tried a Currency £3.20 times Quantity 2 I get = 6.0 not 6.40 as expected (we use pounds here in Scotland). Any setting/selection for this one? I can probably think of a workaround but better if it is just a setting or selection.

Regards Dave Raf

[TigerSoftware]

Hi I tried what was written and it worked (which was good as previously I couldn't getCalcs to work)

BUT when I tried a Currency £3.20 times Quantity 2 I get = 6.0 not 6.40 as expected (we use pounds here in Scotland). Any setting/selection for this one? I can probably think of a workaround but better if it is just a setting or selection.

Regards Dave Raf

Hi Dave,

That may be a bug. I will test it out today and see what is going on. I will post back on this thread when I find something.


Thanks and welcome to the forum. :)


Thomas

[daveraf]

Hi Dave,

That may be a bug. I will test it out today and see what is going on. I will post back on this thread when I find something.


Thanks and welcome to the forum. :)


Thomas
Thomas,

Thanks - for info £1.90 * 2 = 4 and £0.75 * 2 = 2 but £0.74 * 2 = 1 Looks like some rounding going on.

Regards DaveRaf

[TigerSoftware]

Thomas,

Thanks - for info £1.90 * 2 = 4 and £0.75 * 2 = 2 but £0.74 * 2 = 1 Looks like some rounding going on.

Regards DaveRaf

Yeah, that was what I was thinking. I will test it out as soon as I can. I will be releasing an update this week anyway.

I added a way for your users to import csv files into the software. :)


Thomas