+6
I have a question about formatting on IFS lobby.
I want to add a conditional formatting that when the Balance value is higher than the budget value it has to be red color. But how can I indicate this in the formatting tab?
I am not very familiar with the formatting section.
Best answer by Tomas Ruderfelt
View originalYou can’t compare two columns in the element. You have to create a separate column for this.
Example of field in data source:
CASE WHEN balance > budget THEN ‘TRUE’ ELSE ‘FALSE END
Then you can make a condition to show it in bold red or maybe a new column with a red dot or other icon when the value is TRUE.
+6
Hi Tomas,
I have executed your suggestion, but the formatting is not yet applied. By this I mean that the balance does not become red even though it is higher than the budget.
Am I doing something wrong?
You now have made a formatting of the invincible true_false column.
If you instead in the Mapped Column “Balance” add the condition on true_false column it will work better.
+6
Tomas,
I have made the column visible but now the TRUE value turns red and this should be the Balance value.
I am probably still doing something wrong?
Add the formatting on mapped column “Balance” instead of mapped column “true_false”. Then the balance will be red.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
