Calculation headache

[nickOS]

I need some help on a calculation where the original quantity and the balance fields reside on my master database and the inside quantity and the outside quantity fields reside on two different related databases.

I am trying " balance = original Q -( inside Q + outside Q )"

I cant get it to work correctly ( grrrrr !)

Any suggestions ?

Thanks

[Inky Phil]

Hi Nick,

Since you do not say exactly what is not working and assuming that the basis for your calc is essentially correct then check the following.

If Balance is a calc field then the calc should just be '[color:blue]original Q -( inside Q + outside Q )'

You will probably want to check the 'do not store, calc as necessary option.

If you are using a script to set balance then the script step will be

[color:blue]Set Field[balance;Q -( inside Q + outside Q]

IN both instances make sure that when you select inside Q and outside Q that you select them to work via the

relationship[color:red]s which you change at the top of the field selection window.

I am afraid that these suggestions are a bit of a stab in the dark cos you didn't give us a lot to go on

hth

Phil

Edited April 21, 2008 by Guest

[nickOS]

Thank you, you gave me the answer, the calculation was stored.

It works fine now.

Nick