19 Replies Latest reply: Mar 7, 2018 7:59 AM by Sunny Talwar RSS

    KPI Sum expression problem

    Peter Svendsen



      I try to make a KPI that calculate total cost for rearing a car


      The data are spreed in several spread sheets.

      In sheet 1 I have

      Repair no                    Part changed

      1                                   Tires

      2                                   Engine

      3                                   Screw

      4                                   Tires

      5                                   Screw


      In sheet 2 I have

      Part changed          Price

      Tires                         100

      Engine                      8100

      Screw                       1

      Front glass               300


      I tried with this expression

      Sum([Price]*Count([Repair no]))


      But it doesnt work, can you give me a hint whats wrong?