3 Replies Latest reply: Nov 14, 2017 4:22 AM by Andrea Gigliotti RSS

    How to combine different work week across multiple measures

    Martel Masaga

      Hi,

       

      I need to combine different weeks dimension across multiple measure.

       

      For example - I use CR_BKLG_WEEK for CR Backlog $, RS_BKLG_WEEK for RS Backlog $ and Invoice Week for POS and Shipment. Can you help me to create an expression? I started on this below expressions but it didn't work out.


      IF(DBF_ALL_MASTER_QTR=$(vThisQTR),RIGHT(INVOICE_WEEK,4),

      IF(CR_BKLG_QTR=$(vThisQTR),RIGHT(CR_BKLG_WEEK,4),

      IF(RS_BKLG_QTR=$(vThisQTR),RIGHT(RS_BKLG_WEEK,4))))

       

      Thanks