Skip to Content
Author's profile photo Former Member

Conditional formatting based on User input

Business requirement: Highlight any sales revenues that are below sales target, which is a user input control. In other words, if a user wants to highlight any sales revenues that are below $2,000,000 then he can type in 2,000,000 as an input and the result is similar the one below

/wp-content/uploads/2014/05/1_449870.png

Here’s how we can do that.

Step 1: Build a report using eFashion Universe

/wp-content/uploads/2014/05/2_449871.png

Step 2: Create “Sales Target” variable

/wp-content/uploads/2014/05/3_449872.png

Step 3: Design an Entry Field input control on Sales Target

/wp-content/uploads/2014/05/4_449876.png

Step 4: Apply Conditional formatting on Sales Revenues using Sales Target as an input

/wp-content/uploads/2014/05/5_449877.png

Now enjoy the result

/wp-content/uploads/2014/05/6_449878.png

Thanks,

Huu Nguyen

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Koen Hesters
      Koen Hesters

      Hi,

      create conditional formartting rule with formula...as formula try something like

      [sales revenu]=reportfilter([sales revenu])

      but to have the statement reportfilter to work, you have to set your input control over the whole report, not only the table

      Author's profile photo Former Member
      Former Member

      Yes, you are right. However, in some cases, we dont want to set an input control for the whole report, especially when the criteria only apply to a certain measure/dimension.

      Author's profile photo WILLIAM MARCY
      WILLIAM MARCY

      Great Webi trick !

      You've been added to Webi 4.x tricks : summary for a better visibility. Keep posting !

      William

      Author's profile photo Koen Hesters
      Koen Hesters

      Thanks !!!

      Author's profile photo Former Member
      Former Member

      Great trick!