3.3.4 Activity: Create Shipping Metrics by Week

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

This is what my DAT02 Shipping metrics module looks like.

Best Answer

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