11 Replies Latest reply: Feb 22, 2017 7:56 AM by rogerio ferreira RSS

    how to ignore date filter in a cashflow rangesum expression?

    Anat Dagan

      Hi,

       

      I used the below expression to create a cash flow accumulating balance bar chart.

       

      rangesum (above(Sum({<Date>}income)-Sum({<Date>}expense),0,RowNo()))

       

      Below is a snapshot of what the result looks like. It works perfectly as long as i don't filter on the date. How do I lock the date filter and leave the option to filter on other fields  (the data is taken from 3 different banks, i want to be able to filter on each one and get the correct accumulating balance). I am sure it is possible with Set Analysis but i can't get the syntax right.

      thanks in advance for your help.