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

# unable to execute set analysis date wise

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.

• ###### Re: unable to execute set analysis date wise

You can use Day(Date_Column) in your expression

• ###### Re: unable to execute set analysis date wise

I guess your variable formulas are being calculated at the wrong moment. Maybe you should remove the equal signs from your variable formulas, and use \$-sign expansion in your actual expression. Like:

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 )

Pivot table formula:

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

Best,

Peter

• ###### Re: unable to execute set analysis date wise

Dear All,