Search
Search

# In report, there is a formula which shows either values or blank

Hi,

In BW report, We have defined formula to calculate some SLA%. In the output of the report, SLA% shows either some value like 10% or 50% or blank.

But user wanted to see values and zero instead of blank. is it possible? if yes how, please explain me steps.

Thanks a lot in advance and your response is appreciated with good rating.

Regards,

Varun

##### SVU 123replied

Hi Varun,

For testing the Formula,please break up the Formula into diff CFK's

like (A+B/C)*D/100

So make it as

1)A+B=CKF1

2)CKF1/C=CKF2

3)CKF2*D=CKF3

4)CKF3/100=CKF4.

Check for division by Zeros error in the CKFs,else use NODIM function everywhere.Plse be careful with the bracketing().

and then try as to where it is going wrong also try it out in an excel sheet also and Compare both.It shud match,else ur missing something.

For Blanks as Zeros Make the necessary setings in Q.D

Rgds

SVU123

0 View this answer in context
View more on this topic or