AnsweredAssumed Answered

Getting Rid of Blank Records in Report

Question asked by fmpuser0 on Apr 20, 2017
Latest reply on Apr 21, 2017 by philmodjunk

I have a database with the following structure:

 

 

  1. Expense Type -> This account has only two values: fixed expenses and variable expenses
  2. Account
  3. Sub-Account
  4. Date
  5. Concept
  6. Amount

 

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.

Outcomes