cancel
Showing results for 
Search instead for 
Did you mean: 

Urgent!!Total of a KF based on Other KF NEquals 0!!

Former Member
0 Kudos

hi

Does Anyone has an idea of calculating the Total of KEYFIGURE where other KEYFIGURE value not equals 0.

Ex.I have to total the Weightage of a Criteria,where the total weightage of the customer is 0 shld be neglected when totalling the Weightage of criteria.

Thanks a lot.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

in the query designer create a new formula Keyfigure KF2bis as :

= COUNT(KF1) * KF2

So, the total of KF2bis is the Total of KF2 where KF1 <> 0.

Former Member
0 Kudos

hi

Thnx for ur help....

But U r doing muliplication of both the Key figure or using condition in ur mentioned formula...????

COUNT ...Will only count as 1...but not total..but still I can try urs...

But my requirement iss

SCORE TOTWEIGHTAGE TOTAL SCORE NEQ 0

2 6 6

3 0 6

4 12 6

-


-


9 18

As in the above Example....it didnt total the SCORE=3 as total weightage is 0.

This is what I want to calculate...????

Answers (1)

Answers (1)

Former Member
0 Kudos

Helpful Answers