After Using Substitute, Horizontal Checkbox Fields in Reports have E+09 and E+13

February 15, 2025Feb 15

Hello, I am using Filemaker Pro 20 but I’m really a beginner.

I’ve made a simple flat file movie database, just to experiment with.

Some of the fields have yes/no checkboxes. No problems with them.

One field (named “RANGE”) is a checkbox group with four options.

Those values are: 250, 500, 1000, and 2000.

When I generated a report, I noticed the Range field wasn’t displaying all of the values. I widened the box and saw the values were vertical. I wanted them horizontal.

I did some research using AI and found a formula to create a calculated field with the Substitute formula.

Here is the formula I got from AI. I filled in the Range field myself, of course:

Substitute(Range; ¶ ; " ")

It worked, but only to a point. It will display one or two of the checked values properly.

However, if three or all four checkbox options are selected, the report shows this:

2.505E+09
2.505E+13

So, either I designed the database improperly, or the formula is wrong.

Or both.

Or it’s something else.

Could anyone please tell me what is really wrong, and how to fix it?

Thank you very much. Jd

PS: I'm attaching an image that shows the issue. And I've attached the actual database file. Keep in mind, please, it's purely experimental right now. Thank you.