Can you explain what you are trying to do with your calculations and how this is not working for you?
The calculations are pretty simple. Sometimes it's a total of all the fields on a report; other times, it's (Fixed Expenses + Discretionary Expenses) / Gross Profit Percentage. (Still pretty simple; the calculations themselves are not the problem.) The problem is that I'm using this for a variety of different types of companies. So their Charts of Accounts differ. I want to create the database with all of the accounts that I could see, and I want the reports to filter out those that are empty then show and calculate only on the fields that have data. That way "Cost of Food", for example, will show up on the report that I do for a restaurant, but will not show up or calculate on the same report that I do for a business that doesn't do anything with food. Does this make sense?
Thank you for your help! It's so kind of you!
This might be a case where you need related records in place of your fields. In such case, a list view report based on the related table automatically omits the records that are not needed for the current company record.
But what is not clear, is what you mean by this reference to calculations which does not appear to have any connection to the calculations you just described in your last post:
I thought about doing an If, then, else statement with an embedded is empty, but I don't know what to put for the true. The false, in this case, would be whatever is in the field.
Empty fields set to slide up, resize enclosing part will simply not be visible on your layout when in Preview mode or when printing/saving as PDF. The label text that identifieds the field, however would still be visible and would not slide up. In older versions, we might replace the label text with a calculation field that is empty when the field it labels is also empty so that it can be set to slide up also, but in FileMaker 13, we can use "Hide Object When" to hide the label text and set it to slide up/resize just like the field it labels.
Key facts about sliding layout objects:
- It's only visible in preview mode and when you print/save as PDF...
- Sliding fields will shrink but not expand.
- All layout objects below and in the same layout part as the slide/resize field need to also be set to slide up and resize.
- Objects in headers and footers will not slide.
- Portals will shrink/slide to fit the number of rows of records, but fields within the portal row will not shrink/slide.
- Fields will slide up only if Top alignment is specified for it and will slide left only if Left alignment is specified.
- Consistent side borders are difficult to achieve with sliding fields.
- In FMP13, hidden objects (”Hide object when”) will slide/resize.