Help with Calc.

[scottvaughan]

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?

[-Queue-]

If the first field is a text field, then LeftWords( field1, 1 ) and RightWords( field1, 1 ) will give you the two numbers. But where does the 5 come into play?

[scottvaughan]

The 5 is an order quantity. the customer needs 4@3000 and 1 @ 1500, but the orders always change but the format almost never does. I can easily change the / to something else.

[scottvaughan]

Sorry, The field is a number

[-Queue-]

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?

[scottvaughan]

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.

[-Queue-]

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.

[scottvaughan]

Thanks, worked like a charm