plz reply urgent!!!!!!!!!!!!!!!!!!!displaying the blank space with $0

[Former Member]

Hi all,

Plz help Its very urgent!!!!!!

I have a requirement to show the data of consecutive two months in the report with the difference of two months in another column "variance".

ex: mm1/yyyy , mm2/yyyy, variance = mm1/yyyy-mm2/yyyy

I have made a new selection "&MNTH / Amount" , where in it calculates the prior month with the amount. On the new selection i need to make the amount = amount*-1 and display $0 whenever there is a blank space.

I tried achieving this with a customer exit, but could not succeed.

the final output should show

mm1/yyyy = prior month amount

mm2/yyyy = current month amount

amount needs to show negative value

the blank space should be filled with $0

Thanks

rani

Edited by: rani on Dec 27, 2007 2:08 PM

[jaya_mogali]

Hi Rani,

For KF where you need to show negative amount go to the KF proprties and Set +/- indicator.

To display zero instead of space go to the query properties in query designer and select display zero.

Jaya

[Former Member]

hi

to show negative values for amount

Select mm1/yyyy & mm2/yyyy one by one .

Then in the properties hit the DISPLAY tab.

Then look for SIGN CHANGE.

Use "REVERSE SIGN"

do it for both keyfigures

Secondly,

Hit QUERY from the menu and then select properties

Go to Value Display tab

Here select Zero instead of space or Zero with currency unit....

Try following options until u get required output.

Let me know.

[Former Member]

Have you applied zero suppression in the query? By default, zeroes should not show as space.