AnsweredAssumed Answered

Trouble with reports

Question asked by FilipePimentel on Jan 30, 2014
Latest reply on Jan 31, 2014 by FilipePimentel

Title

Trouble with reports

Post

     Hello, 

     I am trying to run a report basically showing monthly revenue and expenses. However the expenses and revenues come from different tables.

     When I run the report I am getting one line for the revenue (amount is correct) but then I get 10 lines for revenues, all with the same amount (see attached). I have tried everything but nothing is working

     My tables: cashflow, plots and payment

     Cashflow will pull the month and expenses

     Payment will pull the revenue.

     There is not direct link between cashflow and payment, but through plot, as plot pull buyer info from casflow and uses payment so buyer can pay for plot bought. 

     Hope I am making sense. 

     It is driving me insane.

      

     Thanks for any help

Screen_Shot_2014-01-30_at_16.12.13.png

Outcomes