BusinessObjects Board

Newbie - Need Help With Report

Hi,

I am relatively new to BOXI and have created a report using variables. I have used transactional pay data to pull certain element amounts and then used variables to determine the elements I want including in each amount…

However I only want one line of data, but it seems to be pulling through 4 lines of data with blanks as shown in the picture.

I just want one line of data for example to show like below

E 30.34 1.05 7.58
AV 382.2 26.37 191.1
G 357.56 24.67 178.78
OH 615.71 42.48 307.86

I know this will probably be really basic and I’d appreciate anybody’s help

Thanks
BOXI Report.PNG


mrbrad1986 (BOB member since 2018-08-01)

Using =Sum([Variable]) rather than just =[Variable] should do the trick.

As easy as that!! Thank you very much really appreciated


mrbrad1986 (BOB member since 2018-08-01)