Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have a question about using color conditional based on two fields from table. Basically i want to color 1 cell if sales>than budget, but this:
```
if(sum(sales)/sum(budget), LightGreen(), LightRed())
```
is not working. Could someone help me?
Hi,
You can use this expression in background color expression:
if((Sum(Sales)>Sum(Budget)),LightGreen(), LightRed())
Output:
Hope this helps,
help user find answers ! don't forget to mark a solution that work for you and click the like button!
But you are not using '>' symbol but '/' ?
Hi,
You can use this expression in background color expression:
if((Sum(Sales)>Sum(Budget)),LightGreen(), LightRed())
Output:
Hope this helps,
help user find answers ! don't forget to mark a solution that work for you and click the like button!
Thanks @Rams-