Search results for query: *

Forgot to mension entering this in column on report as variable

Hi Date one 04/11/2011 05:20:55 Date two 05/11/2011 06:21:23 trying to deduct one from the other to give result in hours and mins Using Webi version XI Can anyone point me in the right direction - help appriciated

Hi Hilfy I have been playing with your formula and tried =If(FormatDate([Available for Dispatch];"HH:mm:ss"))>="16:00:00" Then RelativeDate([Available for Dispatch]; +1) This does seem to be giving me my required results Thank you for you patience Regards Brian

incidentally, the formula does work without the +1

Hi Hilfy It seems to be the "1" (without quotes) that is being highlighted as error Keep getting error :- The expression or sub-expression at position 95 in the '+' function uses an invalid data type. (WIS 10037) =If(FormatDate([Available for Dispatch];"HH:mm:ss") >= "16:00:00";[Available...

ok, i am a newbie ! how do i - 1. convert [Available for Dispatch] to a string prior to doing the comparison. 2.You want to make sure to use the format string that will left-pad the hour with a zero (0) if the time is less than 10:00.

This is the variable formula in both AVAILABLE DESPATCH and AVAILABLE TIME columns =If([Date Last Hold Removed (all Holds)])='01/01/3000' Then ([Call over (UK)]) ElseIf [Call over (UK)]<[Date Last Hold Removed (all Holds)] Then [Date Last Hold Removed (all Holds)] ElseIf ([Call over...

Hi Hilfy Convert available time to string? Is that format as a number? Tried to do that and go Format error. How do i format to string?

Hi Hifty Thought this looked good, however, getting Invalid indentifyer "TIME"

thanks hilfy for your support have followed suggestion, now got two colums, one formatted as date and the other as time. Column one -[Available to Despatch] (Date Format) Column two -[Available to despatch] (Time format) - i have named this column diffent to the other (called available time)...

Hi Can anyone help Trying to use the mod function in Business Objects (end user web intelligents) = mod([call-over date];1) but keep getting error callover date example - 04/4/2011 09:21:13 trying to sperate date and time into diffent columns as variables Help / direction appriciated...

Hi Can anyone help Trying to use the mod function in Business Objects (end user web intelligents) = mod([call-over date];1) but keep getting error callover date example - 04/4/2011 09:21:13 trying to sperate date and time into diffent columns as variables Help / direction appriciated...

Hi steve In the report, i was hoping to add a column with a variable (if this is the right terminology?) brian

Apologies for accidentally high-jacking a posted thread (Skip Vought) - Wondered why i did not see it displayed I am a newbie, end used in BO (webI). No sure of the terminology correct I want to add 3 days to a date and time, using the following criteria:- Examples: Adding 3 days Mon...

Hi - new user to WebI Trying to use mod function in BO =mod([Available for delivery];1) Keep getting error. The Avaialble for delivery" column contains, date and time, eg 09/02/11 17:57:12 Any help appriciated Brian

Hi I am copying a business object report into excel, then use the "mround" function. This round to the nearest nth Example: = mround(A1,30) rounds the value in A1 to the nearest 30. Can this be achieved in a variable column in Business Objects? Any help appreciated Regards Brian

Hi Newbe to Business objects - end user I have run report and find duplicates See example Short Vin LA123456 LA123456 LA234567 LA235678 LA235678 I only require short vin once and can delete either duplicate. I can do this in excel, but is there a way in BObject, with the help of variable...

thanks Steve worked a treat - I had not set-up variable correctly regards -Brain

Hi Steve, thanks for the response Follwed your example, and formula went in ok, and B Objects confirmed formula correct. However, I am not getting any results in the column. All are blank :-( any idea's? Brian

Hi I am a very newbie in business objects.(end user) Currently, I have to export the file to excel and copy/paste into another file. In excel i have the following formula =if(b2>((today()+8)-30,"No",(if(C2>((today()+8)-30),"No","yes"))) I'm ok with excel, but struggling to convert the...