Carry Forward Issue ?

[#1]

HI All,

I am Having Customers with With Some Transactions...

Total Amount I am calculating on the Basis of Credit & Debit to Till the End of Each & Every Month...

Example:

Transactions are happened In then Total Amount is ---- Jan -200,

         Feb--300,

          June--600

I need to get Mar,Apr, May also With the Feb Amount Should be Carry Forwarded

        Jan -200,

         Feb--300,

         Mar--300

         Apr--300

         May--300

         June--600

Urgent...

Regards,

Helen

I need to get Mar,Apr, May also With the Feb Amount Should be Carry Forwarded

[morganaaron]

Do you need this to be done in the script (i.e. where there is a null, look at the previous record) or in a table in the app?

A way to do it would be to create a chart-table with your month as the dimension, sum(amount) as the expression with full accumulation (so it accumulates as you go along) and then add an extra expression that just says 1 for example, hide this column in the presentation tab and ensure you sort by your Month field in load order if you've loaded in sequential order.

Not pretty (and I'm sure not the proper answer) but it would do what you want!

[#3]

HI All,

I am Having Customers with With Some Transactions...

Total Amount I am calculating on the Basis of Credit & Debit to Till the End of Each & Every Month...

Example:

Transactions are happened In then Total Amount is ---- Jan -200,

         Feb--300,

          June--600

I need to get Mar,Apr, May also With the Feb Amount Should be Carry Forwarded

        Jan -200,

         Feb--300,

         Mar--300

         Apr--300

         May--300

         June--600

Urgent...

Regards,

Helen

I need to get Mar,Apr, May also With the Feb Amount Should be Carry Forwarded

[maxgro]

m:

load rowno() as id, * inline [

month

Jan

Feb

Mar

Apr

May

June

];

left join (m)

load * inline [

month, tran

Jan,-200,

Feb,-300

June,-600

];

t:

NoConcatenate

load

id,

month,

if(len(trim(tran))=0, peek(tran), tran) as tran

Resident m

order by id;

DROP Table m;

[#5]

HI  Can you implement for this qvw...

cumulative issue?

[NavinReddy]

plese check its helpful to you