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

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