Exepenses and Revenues
Guys, I hope I can explain my issue:
Our users are doing FSG's for reporting PTD as well as YTD balances. They are also reporting Budget PTD and YTD and finally Last Year PTD and Last Year YTD. For all of those values they are getting variances (i.e. PTD vs Budget, PTD vs Last Year PTD).
Here is my problem, when the row is comming from expenses account, if PTD is greater than Last Year PTD then the difference must be shown as a negative value (since we expended more this current period), when PTD is lower than Year PTD then the difference must be shown as a possitive value.
Our users are doing FSG's for reporting PTD as well as YTD balances. They are also reporting Budget PTD and YTD and finally Last Year PTD and Last Year YTD. For all of those values they are getting variances (i.e. PTD vs Budget, PTD vs Last Year PTD).
Here is my problem, when the row is comming from expenses account, if PTD is greater than Last Year PTD then the difference must be shown as a negative value (since we expended more this current period), when PTD is lower than Year PTD then the difference must be shown as a possitive value.
0