I have a database with the following structure:
- Expense Type -> This account has only two values: fixed expenses and variable expenses
I need to create a report that shows sub-totals by Expense Type, then Account and then Sub-Account but I need Concept to display only when the type of expense is variable.
I have created the following two additional fields:
- c_Concept: a calculated field per formula If ( PatternCount ( Expense Type ; "Trip Expenses" ) ; Concept ; "")
- c-AmountReports: a calculated field per formula If ( PatternCount ( c_Concept ; " " ) ; Amount ;"" )
I have succeeded in creating the report I want based on these two new fields but I can´t get rid of the blank spaces occupied by them when they contain no text, i.e. when they are a fixed expense despite, having having played with all options available for Sliding.
I am using FMP 11.
Any help in solving this issue will be greatly appreciated.