Hello all,
we got the problem that our query does not display any value in the sum, but we have values in several single entrys when drilling-down on a more detailed level!
We are using a condition in the formula for the key figure.
Do you know such a behaviour? Does anybody have a hint how to solve this problem?
Thanks in advance,
bivision
Hi,
we are using the following formula condition:
(KF1 > 0 ) * KF2 * NODIM(Amount) + (KF1 <= 0 ) * KF3
I'm now on this problem for about 5 days...Bex (neither 3.5 nor 7.0 ) doesn't fully want to execute this formula. I tried several other declarations of this formula, but nothing worked well. In the most times, the first part is being executed well, but the second part not. That's why I now did split up the formula in one IF and one ELSE part. The IF part always seems to work well. The second part not... The KF's are all amounts with same currency (EUR)...
Now, I got to a point that the ELSE-part is working on each single entry...but it doesn't want to sum up... the summation option is set...and it works well with any other formula/condition!
We don't know what to do anymore...
Hope that anyone can give me some more input / hints!
bisivion
Add a comment