tatihulot Posted February 15 Posted February 15 (edited) 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. MovieTest.fmp12Fetching info... Edited February 15 by tatihulot
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now