Shipping time weeks

Brj73
Brj73
in Academy Discussions

'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] 

After applying this i am not getting data populated in shipping time week line item

Tagged:

Comments

  • JaredDolich
    JaredDolich

    @Brj73 

    You're on the right track, you're formula is correct, but you may have overthought the formula. Take a look at YEARVALUE function. This is a better function since its basically a LOOKUP on the time hierarchy. make sure the TRA01 values are showing up.

    YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)')

  • Brj73
    Brj73

    Thanks i got it 

    I had not applied formula in TRO1 shipping metrics by week so it was empty and not populated 

  • anaka
    anaka
    https://community.anaplan.com/discussion/comment/144349#Comment_144349

    Hi I used the function you provided but it is not working for me because of 'level mismatch on common dimension'.

Categories