3 Replies Latest reply: Jun 8, 2017 6:04 AM by Chandrashekar Jakkula RSS

    unable to execute set analysis date wise

    Chandrashekar Jakkula

      Dear All,

       

      facing problem of using set analysis

       

      we are created variables as below

       

      CCR_PPC : 

       

      =sum( { $ <Plant_Code= {'2300'}, Product_Type={1}, Material_Code={'CCRPPC'},  VC.Period=P(VC.Period) >} Quantity )

       

      CCR_PSC :

       

      =sum( { $ <Plant_Code= {'2300'}, Product_Type={1}, Material_Code={'CCRPSC'},  VC.Period=P(VC.Period) >} Quantity )


      When we are using above result in pivot table with expression as below


      if(match(PCSNO,7,8,9)<>0 and Plant_Code=2300,if(Material_Code_Product='PPC',CCR_PPC,if(Material_Code_Product='PSC',CCR_PSC,0)))

       

      then its giving result value of the month not day wise.

      Untitled.jpg