Show range of numbers as text

[Ed_P]

Forgive me my poor English as I live in Holland.

I have a question:

Is it possible to show the result of a calculution as text.

example: if the result of a calculation is < 12 the result shown has to be "Mini".

If the result of a calculation is 12 or 13 the result shown has to be "C-jeugd".

Can this be done in Filemaker.

Thanks!

[TheTominator]

Yes.

You would use something like this...

Case(

myValue < 12; "Mini";

myValue = 12; "C-jeugd";

myValue = 13; "C-jeugd";

"Above 13"

)

Note that this gives the text result "Above 13" as the default value when none of the previous conditions are matched.

[Ed_P]

Thanks TheTominator for your fast reply.

It works. But now I have another problem.

I have 2 fields in table Tb_naam.

Field 1 is a calculated field that shows the age of a player on the first of october this year.

Field 2 has to show the calculated field with the solution you provided.

When adding the solution to field 2, field 1 also show the text and not an number anymore.

I only changed field 2 and not field 1.

Any idea why?

[comment]

Since you posted this under Conditional Formatting...

Mini.zip

[Ed_P]

Thanks a lot.

This solves my problem.