3 Replies Latest reply: Jun 12, 2015 4:22 PM by Chris Duke RSS

    sum(Total $(Variablename)

      I am trying to use a varialbe in an expression. I am sure the syntax is correct but it does not seem to be working. Very frustrating!!!

       

      =$(vTotalCostofQual)

       

      This variable works fine.

       

      =sum($(vTotalCostofQual))/sum(TOTAL($(vTotalCostofQual)))

       

      This does not.

       

      I need to find the Total Cost of Qual as a % of the overall cost of Qual.

       

      The Variable is created in the book not in the script.

       

      count({<[Call Category]={'Fault'}>} DISTINCT CallID)*vCallCost+

      sum({<[SOP Type]={'Return'}>} [Extended Price])+

      count({<[Call Type]={'RTB - F'}>}distinct [CallID])*vRTBCost+

      sum({<type = {'Other'}>} quant * [WebPrice.Standard Cost])+

      count([New Gpid])*(vUPS+vPick)+

      sum({<type = {'Accessory'}>} quant * [WebPrice.Standard Cost])+

      sum({<type = {'Accessory'}>} quant * vPick)

       

      Above is the expresssion that is in the variable,

       

      Any help would be most appreciated.

       

      Richard