Excel formula 1

[bta1322]

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 formula to BO language. keep getting error and then time-out
Question - is it possible? any suggestion? or can you point me in the right direction to learn the way these formulas are inputted?

All help appreciated

Brian

 

[skrandel]

The online help is really good.

A report formula like this would work:

if [date_object1] > RelativeDate(CurrentDate();-22) then "No"
else if [date_object2] > RelativeDate(CurrentDate();-22) then "No"
else
"Yes"

Steve Krandel
Intuit

 

[bta1322]

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

 

[bta1322]

thanks Steve

worked a treat - I had not set-up variable correctly

regards -Brain