BusinessObjects Board

Scheduling BO 6.5

scheduling Broadcast Agent (BCA)
#1

Hi all, hope someone can help me.
I have a bunch of scheduled reports, which run fine. However, in some of the BO reports there are columns that have excel formulas in so that when the data is output to excel it automatically performs the calc. For some reason the scheduler encapsulates the formula with speech marks so the formula doesn’t work in excel. Is there a way around this in BO?
Thanks

talisman_08 (BOB member since 2015-02-02)

#2

Not directly. Anything in a column in a report is assumed to be text. You would have to do some post-processing to remove the double quotes and paste the value back into the cell as a formula.

Joe

joepeters :us: (BOB member since 2002-08-29)

#3

Thanks for quick response. Excel it is then.
Mike

talisman_08 (BOB member since 2015-02-02)