BusinessObjects Board

Hiding $ amount with opposite sign in 2 reports

building reports
#1

Hi I have 2 reports (transfer in and transfer out) if they have the same $ amount but opposite sign, I need to hide the $ amount and sum function will not sum these and show correct total amount.
Transfer In report:
|Asset ID|Transfer Asset Id|Cost Total|
|000000029664|000000003301|$8,043.48|
Total $8,043.48 Transfer out report:
|Asset ID|Transfer Asset Id|Cost Total|
|000000029664|000000003301|-$8,043.48|
Total -$8,043.48
Can someone help me on how to get this work? Thanks

#2

when you combine the data from both reports, the sum-function will sum this to 0,00 so what is the problem?

#3

The problem is we don’t want to combine the reports, we want separate reports but showing a 0 if they have the same amount with opposite signs. Is this possible?

Thanks

#4

Trying to understand what you actually have.
Are they two separate report tabs in the same overall BO report doc or two separate BO report docs?

If they are two separate report tabs, you can create a variable to filter out the rows.

Call it “Filter - 0 Cost Total” and use the following formula for it.
=If(NoFilter(Sum([Cost Total]) In ([Asset ID])) = 0;1;0)

Then add a filter to the report tab to keep the 0.

If they are two completely separate report docs, you would need to think differently and potentially add more data to them.

#5

They are two separate report tabs in the same BO report. Do I need to first add a condition such as this: if [transfer in report].[cost total] + [transfer out report].[cost total]=0, then filter 0 out?

#6

Create the Variable then filter on the variable.