Skip to Content

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

5 Comments
You must be Logged on to comment or reply to a post.