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

    KPI Sum expression problem

    Peter Svendsen

      Hi

       

      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?

       

      Thanks,

      Peter