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))))