Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can try this
Sum(Aggr(Sum([Price])*Count([Repair no]), [Part changed]))
Still it doesnt calculate correct
Based on the sample provided... what is the correct output?
Is 8302 not the right number?
The correct number is 8302
I use the KPI chart, dont we agree that expression should be entered here under Expression?
The screenshot I posted was from QlikView... here is a Qlik Sense screenshot and sample
Where do you enter the formula?
Did you enter it under Expression?
Super, thanks a lot... I will investigate whats wrong with mine.
thanks a lot... I will close the ticket asap I have completed the investigation.
I hope its ok
Sure it is