Mr.Bill

Hello and Happy Holidays, Thanks for all your help. I've explored various ways and due to my current FMP ability, I am going to just create a whole bunch of fields for now. I tried creating repeating calculations fields, but got stuck how to dcreate a different calculation for the different repeated fields (sub field). Anyway, again, thanks! - Mr. Bill

Hello Everyone. All your suggestions are very much appreciated. I am going to try these different ideas and see what happens (I'll report back). As for why am I trying to avoid using fields, its simply a matter of keeping the foundation tight and manageable. Basically KISS :. Looks like it will be field based, but I am going to try some of these ideas. Again, many thanks for the great support!!! - Mr. Bill

Hello- Thanks for all the attention. You are correct, this is very spreadsheet like. I would create this in excel, but it needs more of a DB behavior and in this case, FM seems to be the best fit. To help clarify, its a pretty basic DB that is very financial solution focused. The user enters numeric data, and the database reacts with giving the results of the data that has been inputed. There needs to a be multiple records as well as published to the web. Thus the reason why FMP fits the bill. I do like the idea of 1 calculation cell acting as 5 calculations. This would cut all the required calculation fields down by 5 which is a huge help. I'm also going to look into the other suggestions. Thanks again for the assistance!

Hey Lee- Thanks for the quick reply. I want to be able to make a simple arithmetic calculation of 2 fields. Example: FieldName 1 * FieldName 2 = I don't need to keep track of the result for anything. Its just for the viewers reference. I wouldn't mind creating the field, its just that for each layout, there are well over 200 and this creates a lot of fields. In the meantime, I will look at your help suggestion. Thanks again!

Hello- Total NB to FileMaker, but really great product! Question: Is it possible to do a calculation outside of a field. Example: Is there a trick within a standard text box? Thanks!

Great! Thanks for the help. This is what I was looking for. - Mr. Bill

Hello Thanks for the reply. I've read through all the help files, looked around the web and searched this forum. I am exporting in excel format. The challenge is that FMP exports the data in one long row (2 if I choose to include field names). Looking for a way to have it in column format. Its much easier to deal with 100s of fields in 1 long column than in 1 long excel row. Thanks.

Hello- This is probably a basic question, but I can't find a solution. When exporting data to Excel, it all exports great, but all the data exports to one really long row. I'm exporting about 200 fields and it would be great to have it all appear in one column instead of 1 row. Any suggestions? Thanks in advance for the help!