3 Replies Latest reply: Mar 9, 2015 9:43 AM by Chris Lofthouse RSS

    Calculation in a chart

    Håkan Fogelin

      Hello,

       

      I would like to cound customernumbers that meet certain criterias.

      I will Count all customernumbers where the customer has sum(DebPris)>30000

      and where the sum is bigger this month than the previous mont. It´s the part I

      have marked with bold text I cannot get running.

       

       

       

       

       

      count({$<$(vSetMTD),[Segment]={"Glas"},[KundNr]={"=Sum([DebPris])>=30000"},

      {Sum({$<
      $(vSetMTD),[Segment]={"Glas"},[KundNr]={"=Sum([DebPris])>=30000"}>} [DebPris]) >

      Sum({$<
      $(vSetPreviousMonth),[Segment]={"Glas"},[KundNr]={"=Sum([DebPris])>=30000"}>} [DebPris]
      )}

      >} Distinct(KundNr))

       

       

      kindly

      Håkan