Search results for query: *

Thanks guys... Vidru's post sorted me out. Cheers JB

I know that I am being really thick.. However, I need this syntax pretty quick and I haven't got time to go to the quacks to get some memory pills! When adding a variable to count the days between is it possible to count the number of working days between? If so how the heck do you do it...

I know that I am being really thick.. However, I need this syntax pretty quick and I haven't got time to go to the quacks to get some memory pills! When adding a variable to count the days between is it possible to count the number of working days between? If so how the heck do you do it...

hi folks, I don't suppose any of you have a basic report writting training document that could be sent to me?? We have neither the time or resources to go on courses and could do with a business objects for dummies manual!! Cheers JB

I could do without having to sum it up afterwards. It is meant for a summary sheet which summarises data from a report on another sheet. I am not sure if I am able to do this but am eager to give it a try but with my limited knowledge it may not be possible. JB

I am wanting to write a variable that uses conditional functionality I am wanting to count a certain data item where the value is less than 2 =If <Time Between IC and End of IS> < 2 Then Count I am very new to Business Objects and am still finding my feet Cheers JB

You had an extra bracket on the end! But other than that it works perfectly.. Thanks a million JB

Hi Guys, I am trying to write a variable which is an if statement with in Business Objects but it isn't playing ball. This is what I think I wanna type: =If<Outcome Date> = &quot;&quot; Then(DaysBetween(<Initial Contact Date(Query 4 with BOCI001U)> , CurrentDate())Else(DaysBetween(<Initial...

I have a query which I have compiled in Query Builder. However I am wanting to stick a prompt in and cannot get it to work. Although QB allows me to run the report finding no errors it doesn't prompt me and it produces no results and I know that there should be. The line in particular is...

Didn't realise how easy Oracle was... Am learning more and more each day.. Thanks for the prompt reply. JB

No I am not joking... Just becuase it says programmer by my name doesn't mean I know about Oracle. I have very limited Oracle experience.... Where can I find out about the command &quot;? Explicit subtraction&quot;? Thanks

Got a sticky problem which is causing me a few problems in Query Builder Oracle...... HELP PLEASE!!!!! I have a date and I want to know how many days have passed. I have used the help facility and so far have come up with: MONTHS_BETWEEN(SEV_ACTUAL_DATE, SYSDATE) This returns the months between...