KPI Sum expression problem

[Anonymous]

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

[alexsid-qlik]

Hi, 

I am having a similar problem. How do you get the number 8302 in the blue box? For me it shows 42,505 as KPI when using Sum([Price])*Count([Repair no])

Thanks!