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
Edited by: rani on Dec 27, 2007 2:08 PM