Calculation of weeks syntax.

Tue, 01 Oct 2013 09:50:17 GMT

Hi i have the following Scenario

i am calculating the week no whereby a product will need to be reordered.

i use a factor whereby i have calculated the avg, for example if the availability of the product is 500 pieces and the consumption is a thousand on average the factor 0.5, which equals that the product will run out this week.

this works fine in the calculation below,

however on the otherside whereby i wish to see in the future how long the product will last = week no i am getting some strange results

for example 201369 .it should show 201417?

is there any way to code this to show the 201417 instead of 201369?

Syntax:

if( Column(3) / Column(5) <1, max([Year Week]),

max([Year Week])

+ (round(Column(3) / Column(5))))

topic Calculation of weeks syntax. in QlikView

Calculation of weeks syntax.