Skip to Content
0
Jul 01, 2009 at 09:54 AM

Replace the value 733.534 in reporting.

21 Views

Hi Experts,

I am facing one problem in reporting. I am in BI 7.0 environment.

Reports are export to EP everthing is good,

Issue:

one column displaying value like -733.534

my requirement is don't display this value istead of this should display same flag or colour ....

Root cause:

this fields is calculated in the reporting level, so this is not coming from any data target.

calculation: Days from two different Dates.

eg; offer given date - offer excepted date = Days( resulet)

I calculated by farmula with replacement path.

this -733.534 value is displaying only when any one of the two dates are missed then this value will displaying.

if both dates are in reporting calculated value is displyaing right. (currect result).

can any help me how to replace the value -733.534 by any flag or colour.

Regards

Vijay