Back Order Calculation

[#1]

Dear All,

I have issue with calculation of Back orders.

Actually we have data as some backorders are generated and some released in particular date time , So remaining back orders are to be carry forward for next date time interval.

But this functionality I am unable to implement.

Kindly suggest if anyone have some solution for it.

Example\

YearMonth          BO_generated          BO_released

201211               10                            5

201212               15                            12

201301               5                              6

Calculation should be >>

201211          10          5          5

201212          15         12        3+5=8   

201301           5           6        -1+8=7

Thanks & Regards

Nitin Gupta

YMSLI

8802744818

[Anonymous]

Does this post help ? http://community.qlik.com/message/299811#299811

Jonathan

[sujeetsingh]

Hi ,

jonathan had given a clear picture and solution...

use above function

[#4]

Hello,

I think I was unable to explain my problem in a correct way.

I am attaching an example .

Here there are 4 expressions as pre bo, fixed do, delivery, actual  bo

Actually prebo is bo generated previously of selected year month.

and actual bo is fixed do-delivery+prebo.

This actual bo will act as prebo for another day.

I was actually busy in some other project, but now situations have become critical for me.

If please provide me some suggestion how to achieve this concept.