I use Business Objects at work and I'm learning as I go with the help of your videos. One thing I'm currently learning more of is the use of formulas when creating variables which can be a headache at times when they get long. Maybe you could do a video explaining some of the complex formulas in the future.....just a thought.
FYI, Your RIGHT formula for removing the 'FY' value in the Year column does not cause the Consolidated Revenue to aggregate.
Good job on the rest though!
wdblackman 2 months ago
Shouldn´t be the consolidated revenue column like this? =If(IsNull([Sales revenue]);[Revenue];[Sales revenue]+[Revenue]) Summarizing both revenues?
THanks for the videos!!!
honbed 6 months ago
@honbed I would have done it the following:
If(IsNull([Sales revenue]);0;[Sales revenue]) + If(IsNull([Revenue]);0;[Revenue])
seyhmus79 4 months ago in playlist BOBJ
Great information!
I use Business Objects at work and I'm learning as I go with the help of your videos. One thing I'm currently learning more of is the use of formulas when creating variables which can be a headache at times when they get long. Maybe you could do a video explaining some of the complex formulas in the future.....just a thought.
CrimsonTide81 8 months ago
Thank you for sharing!
isnookee 8 months ago