Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to set condition for a value that fall within a range.

Hi,

I have a parameter and value should fall within the range 6 to 8. Value should be highlighted if it does not come in between this range

How can I set this condition is font style . I have other parameters as well in the report. All these parameters have different conditional values. This is a cross tab report.

Can I define this conditions in a formula field. If yes, how can I call in the font/style tab to set the condition.

Please Advise.

Jessy.

Former Member
replied

Hi Jessy,

Right-click the crosstab cell that you'd like to be format > Format Field > Font tab > Click the formula button beside Color and use this code:

If Not(currentfieldvalue IN [6 to 8]) then

crRed

else

crNoColor

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question