a waterfall question

[Anonymous]

hi friends,

need some help here on one of the waterfall request as attachment.

1.to calculate DDLT quantity(sum of forecast qty highlighted in green one) based on LT + 1. eg. if LT = 10, sum 10+1 forecast quantity column to get the DDLT quantity

2.to get previous DDLT. is this Peek('DDLT')?

thank you and have a nice day.

[ogautier62]

Hi,

in a graph use : above to get previous (line above) :

example :

Prev DDLT = above(DDLT)

regards

[Anonymous]

hi Olivier,

thanks for the response.

any suggestion how to come out the formula for the 1st item?

DDLT quantity(sum of forecast qty highlighted in green one) based on LT + 1.

eg. if LT = 10, DDLT quantity= sum total of 10+1 forecast quantity column

      if LT = 12, DDLT quantity= sum total of 12+1 forecast quantity column

the key is CPN+region+Fcst Crtd Date.

thanks.

[ogautier62]

OK,

so use expression :

RangeSum(Above(sum(quantity),0,LT+1))