5 Replies Latest reply: Sep 7, 2015 3:40 PM by Ramon Covarrubias RSS

    How do I show the last balance on the last day of the month where the balance occurse more than once?

    Andrew Smith

      Hi,

      I have a monthly spreadsheet which I download from my bank to show Date, Transactions, Money In, Money Out and Balance.

       

      I want to be able to display a Straight Table showing the Last day of the month and the balance on that day. The main issue I have is that because there are more than one transactions on the last day of the month there are multiple Balances and I only want the Minimum Balance within that group.

       

      I have tried

      • Dimension of MonthEnd(Date) and Expression of Only  (Balance) ... that didn't work - which I expected
      • Dimension of MonthEnd(Date) and Expression of Min (Balance) ... this gives me the minimum balance within the month and not on the last day of the month

       

      I have tried some weird and wonderful Set Analysis expressions which give me some amazing results, none of which are correct including using max(RecNo())

       

      Anyone got any ideas??