Calculation

[Lucky]

Hi

Is it possible to have a calculation that looks at several fields to determine a answer such as:

Field 1= Artwork

Field 2 = Stereos

Field 3 = Premount

Field 4 is the calculation.

Each has a pull down menu of "Yes" or "No"

What I would like is if:

Artwork = Yes

Stereos = Yes

Premount =Yes

the answer to be " Artwork-Stereos-Premount "

Artwork = Yes

Stereos = No

Premount = No

the answer to be " Artwork Only "

Artwork = No

Stereos = Yes

Premount =No

the answer to be " Stereos Only "

and so on.

Any ideas

[BobWeaver]

Substitute(Trimall

(Case(Artwork="yes";"Artwork ";"")&

Case(Stereos="yes";" Stereos ";"")&

Case(Premount="yes";" Premount";"");1;1);" ";"-")

Or:

Let([

words=Case(artwork="yes";"Artwork ";"")&

Case(stereos="yes";" Stereos ";"")&

Case(premount="yes";" Premount";"");

Only=Case(WordCount(words)<3;" only";"")];

Substitute(TrimAll

(words;1;1);" ";"-")&Only)

[Lucky]

thank you

[Lucky]

If I wanted to apply this calculation to a DB in FM V6 what would it need to say?

Peter

[Søren Dyhr]

Enders first calc should do it ...when finished !!

However would I approch such a matter this way:

Choose (

Case ( PatternCount ( Artwork ; "yes" ) ; 4) +

Case ( PatternCount ( Stereos ; "yes" ) ; 2) +

PatternCount ( Premount ; "yes" );

"";

"Premount Only";

"Stereos Only";

"Stereos - Premount";

"Artwork Only";

"Artwork - Premount";

"Artwork - Stereos";

"Artwork - Stereos - Premount")

--sd

[Lucky]

Thanks