Euro conversion... 
Author Message
 Euro conversion...
Hello,

little problem, for the moment I still recieved the bills in two
currencies and that's the reason why I've done a calculation field for
the Euro and I've done the same in the summary fields but next year the
bills'll be in Euro only.

My question is on one hand I would like to keep the result of the
calculation field in Euro for next year but I would like to be able to
insert the amount in Euro directly instead of the national currency is
there a way to do that with FileMaker?

I thank you for your answer.

Thierry



Sat, 21 Jun 2003 14:06:08 GMT
 Euro conversion...

Calculated Euro=Case(IsEmpty(National Currency Field), Euro Field, National
Currency field*Conversion Factor).

Always a problem trying to accomodate a choice between a direct value
insertion and a claculated value. There is no way a calculation field's
value may be manually inserted; it must be the result of a calculation. But
it can, as above, test to see if the calculation is needed, and if not, use
the unconverted value ("Euro Field").
--
John Weinshel
datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> Hello,

> little problem, for the moment I still recieved the bills in two
> currencies and that's the reason why I've done a calculation field for
> the Euro and I've done the same in the summary fields but next year the
> bills'll be in Euro only.

> My question is on one hand I would like to keep the result of the
> calculation field in Euro for next year but I would like to be able to
> insert the amount in Euro directly instead of the national currency is
> there a way to do that with FileMaker?

> I thank you for your answer.

> Thierry



Sun, 22 Jun 2003 00:19:04 GMT
 Euro conversion...

dear John,

I thank you very much for your answer.
I've done a small test and it's working fine, I'll use the Calculated
Euro field in the listing and during the transition I'll keep the
National Currency and Euro fields on the layouts.

It's time to learn a little bit more the functions included in FileMaker...

Best regards,

Thierry

John Weinshel a ecrit :

Quote:

> Calculated Euro=Case(IsEmpty(National Currency Field), Euro Field, National
> Currency field*Conversion Factor).

> Always a problem trying to accomodate a choice between a direct value
> insertion and a claculated value. There is no way a calculation field's
> value may be manually inserted; it must be the result of a calculation. But
> it can, as above, test to see if the calculation is needed, and if not, use
> the unconverted value ("Euro Field").
> --
> John Weinshel
> datagrace
> Associate Member, Filemaker Solutions Alliance
> Vashon Island, WA
> (206) 463-1634i



Sun, 22 Jun 2003 07:08:57 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. euro conversion problem

2. Information_schema used for EURO-conversion ?

3. euro conversion problem

4. need magic formula for euro conversion

5. Euro conversion ????????????????????

6. Euro conversion

7. euro conversion

8. Euro conversion to be stored on decimal column

9. serverhousing - FLAT Rate - 150 / Euro Month

10. Codepage 850 support for the Euro Symbol

11. Code page problems - pound sign, euro sign sometimes translated

12. EURO-sign


 
Powered by phpBB® Forum Software