Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Weekly average when daily calculation involves lag (PREVIOUSDAY (or DATEADD('Date', -1, DAY)))

I have the following dataset:     The formula for storage flow is HeldInStorage (day X) + Supply (day X) - Demand (day X) - HeldInStorage (day X - 1).   So for a daily measure, the followi...
  • daXtreme's avatar
    daXtreme
    4 years ago

    Hi Anonymous 

     

    What exactly does it mean "the formula fails"? You have not shown any output. At first glance the formulas seem to be OK but without seeing the wrong results and the expected output it's not possible to diagnose.

daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
4 years ago

Hi Anonymous 

 

What exactly does it mean "the formula fails"? You have not shown any output. At first glance the formulas seem to be OK but without seeing the wrong results and the expected output it's not possible to diagnose.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

When I prepared the results to answer you, I noticed the results were fine.

I must have made a mistake when checking the first time.

Cheers

 

results match