Jump to content

Help with Calc.


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

Recommended Posts

I need to calculate a number. The calc is from 2 fields

The first is a coded number of 3000/1500. The 2nd is 5. So the calc for this example would be 4(3000)+1(1500) for a total of 13,500. How do I get Filemaker to recognize the 2 different numbers? Can I tell it to see one on the left of the slash and then see the one on the right?

Link to comment
Share on other sites

Well, it should be a text field; the slash will be ignored in a number field. A number field should only be used for a single number.

So that 5 is split into 4 and 1? How do you know in what way it should be split?

Link to comment
Share on other sites

All of the numbers change depending on the job. The 5 could be anything, but the full order is always 1 less than the number. So if it were 15, it would be 14(3000) + 1(1500). The 3000 and 1500 can change as well. The clac needs to get the total order and i want to try and keep it in the same field.

Link to comment
Share on other sites

Okay, change field1 (with the two numbers) to a text field and then use

Case( field2, (field2 - 1) * LeftWords( field1, 1 ) + RightWords( field1, 1 ) )

Of course, ideally each number would be placed in its own field, making things much simpler.

Link to comment
Share on other sites

This topic is 5640 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
 Share

×
×
  • Create New...

Important Information

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