topic Running sum based on outflow/inflow cash in QlikView https://community.qlik.com/t5/QlikView/Running-sum-based-on-outflow-inflow-cash/m-p/401995#M149596 <HTML><HEAD></HEAD><BODY><P>My pivot table looks like this: <A class="loading active_link" href="http://i49.tinypic.com/ofsxs7.gif" title="http://i49.tinypic.com/ofsxs7.gif">http://i49.tinypic.com/ofsxs7.gif</A></P><P></P><P><IMG class="jiveImage" src="http://i49.tinypic.com/ofsxs7.gif" /></P><P></P><P>It's sorted by date DESC (First dimension, "Effective Chec...").</P><P></P><P>I'm trying to get a running sum to get Amount of cash on hand in the "Amt" column.&nbsp; You can see the Inflow and Outflow columns to its left...</P><P></P><P>I tried this, didn't work: =RangeSum(Above(TOTAL Sum(Amount),0,RowNo()))</P></BODY></HTML> Wed, 10 Oct 2012 23:17:06 GMT 2012-10-10T23:17:06Z Running sum based on outflow/inflow cash https://community.qlik.com/t5/QlikView/Running-sum-based-on-outflow-inflow-cash/m-p/401995#M149596 <HTML><HEAD></HEAD><BODY><P>My pivot table looks like this: <A class="loading active_link" href="http://i49.tinypic.com/ofsxs7.gif" title="http://i49.tinypic.com/ofsxs7.gif">http://i49.tinypic.com/ofsxs7.gif</A></P><P></P><P><IMG class="jiveImage" src="http://i49.tinypic.com/ofsxs7.gif" /></P><P></P><P>It's sorted by date DESC (First dimension, "Effective Chec...").</P><P></P><P>I'm trying to get a running sum to get Amount of cash on hand in the "Amt" column.&nbsp; You can see the Inflow and Outflow columns to its left...</P><P></P><P>I tried this, didn't work: =RangeSum(Above(TOTAL Sum(Amount),0,RowNo()))</P></BODY></HTML> Wed, 10 Oct 2012 23:17:06 GMT https://community.qlik.com/t5/QlikView/Running-sum-based-on-outflow-inflow-cash/m-p/401995#M149596 2012-10-10T23:17:06Z