1 Reply Latest reply: May 10, 2016 1:36 PM by Thirumala Dandamudi RSS

    Set Analysis is giving error

    Pankaj Purohit

      Hi,

      As I am trying to run st analysis for my one of the task but when I am creating it it shows error indication near curly bracket of kCommodity_ID so can anyone help me in this regards. I am pasting the script below:

       

       

       

      =fabs(Sum( {<GetCurrentField( {kCommodity_ID)='$(=Commodity_ID)')} >= PY1Month_Consumption_Baseline)}* if(Only( {<To_Consumption_UOM_ID={'$(=To_Consumption_ID)'} >} Consumption_Conversion_Factor)<>null(),Only( {<To_Consumption_UOM_ID={'$(=To_Consumption_ID)'} >} Consumption_Conversion_Factor ),1) 

        • Re: Set Analysis is giving error
          Thirumala Dandamudi

          See below for the correct expression:

          =fabs(Sum( {<GetCurrentField( kCommodity_ID)={'$(=Commodity_ID)')} >= PY1Month_Consumption_Baseline)}* if(Only( {<To_Consumption_UOM_ID={'$(=To_Consumption_ID)'} >} Consumption_Conversion_Factor)<>null(),Only( {<To_Consumption_UOM_ID={'$(=To_Consumption_ID)'} >} Consumption_Conversion_Factor ),1)