Search the Community
Showing results for tags 'percentage'.
Found 3 results
Hi there I'm trying to put together a couple of A4 landscape layouts which would show a total of 4 line charts on each, therefore each chart needs to be the same size. The data being presented in each chart is percentage data which is pre-calculated, so it's easy to plot onto the chart, the problem is with the crazy spacing that FM assigns to the Y-axis.]# I initially created the chart with min and max values of 0 and 100 respectively, but when I resized the chart, it shows (useless) values on the scale such as 16%, 26%, 42% etc. Whatever size I choose, I want it to show 0,10,20,30 etc. Can FM manage this? Secondly, some data series lines look very flat when viewed on a 0-100 scale, so instead I can narrow the scale to say, 40-60 (which I know is where the majority of the data points for that series lay). Once again I'm faced with the same problem when the highest value on the chart is like, 58%. Instead, I'd like it to perhaps go 40,45, 50, 55, 60 or whatever suits. Can FM manage this? I'm aware the charting function is limited, but surely you must be able to manually set a scale? Thanks
Hi, I think I must just have some weird setting in place but I can't for the live of me find it. Every time I set a number field to display as a percentage it shows it as a percentage times 100. For e.g. If the number in "general" format is 40, and I set it to percentage it changed to "4000%". It's clearly only a display issue, as if I change it back to general it displays in the original format. Anyone have any idea what could be causing this? I've tried the same thing in a new database with the same result, so I assume it's a preference in FileMaker.
I've got a bunch of student records, which include nationality and a progression decision.Â I would like to see the progression rate by nationality. Â I've attached a screenshot of what I'm currently getting on a layout with sub-summaries sorted by nationality. Â Â The # of students and the # of students progressed seem to be working.Â These are both summary fields, with the progressed number being the total of a calculation that is 1 if they progress and 0 if they don't.Â For the %, I have a numeric calculation field where I divide the two summary fields: (s_countStudentsProgressed / s_countStudents) Â As you can see, the percentage I'm getting is that total overall progression rate, rather than the value in each sub-summary section.Â What am I missing?Â I can't use the "fraction of" summary field, because I don't want to know what percentage of our progressing students come from a certain country.Â I want to know what percentage of students in a certain country progress. Â Any help would be greatly appreciated.Â And if you have any questions for me, please don't hesitate to ask. Â Thanks! Dave