Cash Flow

[gidon500]

Hi guys

my customers whats  a cash flow documents

I get ( enclosed a file )

list of expenses with dates , sum and type of expense 

I need to create an object  that give me the expected cash for a certain date

I do not know how to get data from one cell up in an object

thanks

gidon

[PrashantSangle]

Please find attachment.

Regards,

[gidon500]

Hi

thank you very much for your fast response

it seems not to work in my models

the command

Above(isnull(DATE))

does no seem to work

do I need to define any documents parametrs

the test you sent me works great

thanks

gidon

[gidon500]

Hi

enclosed is my docs , can you see why it does not work

thanks

gidon

[sunny_talwar · Accepted solution]

You can also try this

25248 - RangeSum(Above(Sum(TotalShekel), 0, RowNo()))