By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,454 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Help With SAP Business Objects Formula

USTRAGNU1
P: 32
Good Afternoon,

Would anyone be able to assist with a Business Objects XI 3.1 formula question? I don't see it as one of the topics.

Thank you.
6 Days Ago #1
Share this Question
Share on Google+
5 Replies


Rabbit
Expert Mod 10K+
P: 12,327
It's not one of the existing topics but you're more than welcome to ask the question and hopefully someone comes along that can answer it.
6 Days Ago #2

USTRAGNU1
P: 32
Ok thanks Rabbit.

I have a Business Objects XI 3.1 variable formula which places an asterisk and a space in front of a date object if the object date is less than or equal to current date. Simple enough.

But I am trying to modify the formula so that if the condition is met and the output does contain an asterisk, I want the font of the asterisk/date to be red, preferably bold. My searches keep returning examples of using the built in conditional formatting tool (Alerter), but I would need to use a variable in the Alerter anyway.


Here is the formula:

Expand|Select|Wrap|Line Numbers
  1. = If( [Date]  <= CurrentDate() ; "* "+FormatDate([Date] ;"MM/dd/yyyy") ; FormatDate( [Date]) )
Again, if possible, modify the formula so the date outputs with asterisks will be bold red font.

Thank you very much. Please let me know if you require additional information.
6 Days Ago #3

Rabbit
Expert Mod 10K+
P: 12,327
Typically, formulas output the value to display, not the formatting. Conditional formatting is usually handled elsewhere, in this case, it sounds like this Alerter thing you mentioned. Is there a reason you can't use the Alerter to do the conditional formatting you're talking about?

For example, in Excel, the formula bar let's you output different values based on other conditions. No amount of changing the formula let's you change the formatting of the cell. To dynamically change the formatting of the cell, you have to use the Conditional Formatting functionality in Excel.
6 Days Ago #4

USTRAGNU1
P: 32
The Alerter can't isolate just the asterisk in the date string. I would have to build a formula inside the alerter anyway.
5 Days Ago #5

Rabbit
Expert Mod 10K+
P: 12,327
You mean you just want one part of the string to be formatted differently from the rest of the string? Typically, an object is formatted with one format. In this case, the entire text box can only be formatted with one format. If you want to format the string into two different formats, just break up the string into two text boxes. One textbox for the asterisk. And a different textbox right next to it with the date.
5 Days Ago #6

Post your reply

Sign in to post your reply or Sign up for a free account.