I have (1) table with a sum for each section. Which has a total for all the sums.
Then on the same report I have another table with a sum for each section.
I need to sum the sums on the second table and then do a grand total for both tables.
Help.[ponder]
I need each section on the report to show up on a seperate page. I have tried formating the table and the cell that the section is grouping on with no luck.
I also tried breaking the report on the same field that the section is based on, and when I do that it will apply the break to seperate...
BO 6.5.1
I need a formula that will do the following:
If <Account> = (123%) then "New Account" else if
<Account> = (534%) then "Old Account"
Basicaly I want to check the first 3 digits and then assign them to a catorgory.
Thanks Rick.
BO 6.5.1
This is what I am doing:
=<Total Amount> where (<Account> = "2342") This Works!
My problem though is I have multiple accounts I need to check for so if I add to this query in any way it will not work. It comes back incompatable data or syntax error.
I have tried InList, In, or, and...
I need to create a formula that can perform a wild card like ("0120%":
If <Account> Starts with "0102" then "New Account" Else if
<Account> Starts with "1233" then "Old Account"
I have tried several methods, but they are acting more like a filter then delivering the desired results.
I am...
I am trying to do a variance between two cells and the data in 1 object has undefined cells. I tried using the undefined setting in format cells, the formula stills does not reconize it as a numeric 0.
Business Objects 6.5
Thanks Rick
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.