In Activity 3.3.5.2B Shipping Line Items @ Sprint3, Same values are populated for all weeks

Options

Hi all,

In Activity 3.3.5.2B Shipping Line Items @ Sprint3, Same values are populated for all weeks.

What is wrong I did. Please let me know.

Thanks

Answers

  • Hey Psn006:

    The YEARVALUE formula returns the Yearly summary value from the source.

    Meaning for Nutzo bar / Air the FY 2020 total in DAT02 is a value of 1.

    What are the time dimension of DAT02? If no time as a dimension, see if you can use the SUM formula with a week based line item from DAT02.

    If DAT02 is dimensioned by week, you can just take out the YEARVALUE formula.

    Best,

    Dan

  • psn006
    Options

    Thank you danial.