on 12-17-2007 2:37 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...????
Helpful Answers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.