FM 8.5

I have a setup that deals in several currencies. I am trying to create
a system whereby the currency symbol displayed alongside a price field
is a function of the text content of a Sku (here called Product Tag).

Rather than formatting the Price field, number, with a currency symbol
- and since I do not know how to create conditional formatting, I
would create a Currency field that displays the desired result based
on other data.

I could make the Currency Field part of the Product Table but my
Invoice has a fields outside the Line/Product portal, such a subtotals
and below the line sums.

Therefore I created Currency Field with the following calculation;

Case(
PRODUCTS_EURO 2::Product_Tag and Left ("E";1); "€" ;
PRODUCTS_EURO 2::Product_Tag and Left ("C";1); "$" ;
PRODUCTS_EURO 2::Product_Tag and Left ("U";1); "$"
)

Then Product Tag - EDB40BG , would produce the result € and UWC33BW
would produce $ etc..

This is not working. Any explanations or thoughts on my approach?

Thanks
Matthew

On Jan 17, 8:32*pm, Buckbuck <buck.matthe... (AT) yahoo (DOT) com> wrote:>
Your general approach is ok, though depending on the number of
currencies, I'd consider a lookup table.

In terms of your calc, I'd recommend reading the help file on the
syntax of the Left() function. Your calc will never work the way it's
written.

G

"Buckbuck" <buck.matthew74 (AT) yahoo (DOT) com> wrote

FM 8.5
It's the right approach, but your comparisons are wonky and are not testing
what you think they are.

In English what you are trying to do is:
If the Left character of the data in the Product_Tag field is an "E",
then use the Euro symbol,
If the Left character of the data in the Product_Tag field is an "C",
then use the Dollar symbol,
If the Left character of the data in the Product_Tag field is an "U",
then use the Dollar symbol,
etc.

Change this directly into FileMaker comparisions exactly as they read above:
i.e.
Case(
Left(PRODUCTS_EURO 2::Product_Tag ;1)="E"; "Euro";
Left(PRODUCTS_EURO 2::Product_Tag ;1)="C"; "$";
Left(PRODUCTS_EURO 2::Product_Tag ;1)="U"; "$";
etc.
)

There's no "ands" in the English version, so there's no need for "ands" in
the FileMaker comparisons.

(I haven't tried to put the actual Euro symbol in since it may get dropped
out by some newsservers / newsreaders.)

Helpfull Harry )