3.3.4 Activity: Create Shipping Metrics by Week

Carlos3k
Carlos3k
in Academy Discussions
image.png

I keep getting invalid formulas. What am I doing wrong?

image.png

This is what my DAT02 Shipping metrics module looks like.

Best Answer

  • Venki9902
    Venki9902
    Answer ✓

    Hi @Carlos3k,

    Formula seems is right but you have missed single quote in cost per 1000 units line item.

    Add single quote in the end you will get the data.

    Attaching formula for your reference.

    YEARVALUE('DAT02 Shipping Metrics'.'Cost per 1000 Units')

    Hope this help :)

    Regards,
    Venkatesh

Answers

Categories