2 Replies Latest reply: Dec 19, 2017 3:22 PM by Jörg Wünstel RSS

    only Sum of Sales Country > 1.000.000 - KPI

    Jörg Wünstel

      I tried to addust following formula from the help section.

       

      sum( {$<Customer = {“=Sum({1<Year = {2007}>} Sales ) > 1000000”}>} Sales )

       

      I would only sum Positiontotal of each Country where the total Sum 2017 is above  1.000.000

       

      sum({$<[Countries.Country Name] = {"=Sum({$<[Invoices.Date.autoCalendar.Year] = {2017}>}[Positions.Positiontotal Basecurrency] > 1000000"}>} [Positions.Positiontotal Basecurrency])

       

      Unfortunatley i got Zero as result.

      I tested the formla as a KPI

       

      Could someone help me?