Question:
Hello,
I am trying to use the SUMGT function in a BEx calculated key figure but I get the following problem:
If I have the formula 'column 1 * SUMGT column 2' I only see values for a line where there is a value in column 2. I want a result even if there is no value in column 2 as there is a value for the total of column 2.
Any help would be very much appreciated.
Answer:
Are you on a multiprovider ?
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Yes. Is that relevant?
Answer:
Yes. Because it explains that for the first KF, you can have values, and not on the second.
The problem you have is that SUMGT is only active for rows containing values. In your case, some rows do not retrieve any data, and, thus, BW, doesn't calculate SUMGT.
On a multiprovider, BW create as much queries as you've inforproviders, and then aggreggate the data (well, in fact, it's an UNION SQL query, but the result is the same).
The only way to retrieve your data is to mix KF : Let imagine that KF1 is coming from the most populated infoprovider (which will "drive" the characteristics) , KF2 should be transformed into KF2 * COUNT(KF1), or something like that.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.