7 Replies Latest reply: Jan 11, 2013 7:24 AM by Nirav Bhimani RSS

    Help with Table Expression?

      I have a table with all my outstanding invoices(Customer, Inv Date and Amount) . I am trying to create an age analysis for this - current 30 days and 60 +.

       

      When I do a table with invoice as the dimension it works but when i want to summarize by customer it only calcs the ones with only one invoice.

       

      The expression I use is the following:

       

       

      if([Ageing] <= 31, Sum(InvoiceBal2), '') etc.

       

      I would assume the reason the summary per customer doesnt work is that it doesnt know what the ageing is per customer when there are multiple invoices with different ageing.

       

      Any suggestion how to overcome this?