# Row color on report table if, elif, else

**URL:** <https://forum.inductiveautomation.com/t/row-color-on-report-table-if-elif-else/90510>\
**Category:** Ignition\
**Tags:** ignition80, reporting, ignition81\
**Created:** [May 16, 2024, 4:29pm UTC](https://forum.inductiveautomation.com/t/row-color-on-report-table-if-elif-else/90510 "2024-05-16T16:29:07Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ayanakoji](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@Ayanakoji](https://forum.inductiveautomation.com/u/Ayanakoji)\
**Post date:** [May 16, 2024, 4:29pm UTC](https://forum.inductiveautomation.com/t/row-color-on-report-table-if-elif-else/90510/1 "2024-05-16T16:29:07Z")

</div>

priority=="Low"?"916AAD":priority=="Medium"?"F5E11B":priority=="High"?"EC8629":"E22028"

my expression is not working properly  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/c/cce26b4ec2c8ad146b6c371ac19b2cf6dbf38b02.png)

followed the examples here

> **[Keychain Expressions | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/ignition-modules/reporting/report-design/data-keys/keychain-expressions)**
>
> It's possible to perform calculations on data keys. This section documents the various operators and functions that are available.

---

<div class="post-metadata">

**Author:** ![Duffanator](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/duffanator/32/3560_2.png) [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\
**Post date:** [May 16, 2024, 4:44pm UTC](https://forum.inductiveautomation.com/t/row-color-on-report-table-if-elif-else/90510/2 "2024-05-16T16:44:10Z")

</div>

Looks correct... Are you sure _priority_ is the key and it's not just a column in a larger key? like _MyData.priority_?

---

<div class="post-metadata">

**Author:** ![Ayanakoji](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@Ayanakoji](https://forum.inductiveautomation.com/u/Ayanakoji)\
**Post date:** [May 16, 2024, 4:53pm UTC](https://forum.inductiveautomation.com/t/row-color-on-report-table-if-elif-else/90510/3 "2024-05-16T16:53:39Z")

</div>

yes, its the "priority" key, im using the alarm journal query btw, I already said the data key on the table

---

<div class="post-metadata">

**Author:** ![Ryan\_Deardorff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_deardorff/32/63815_2.png) [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\
**Post date:** [May 16, 2024, 5:13pm UTC](https://forum.inductiveautomation.com/t/row-color-on-report-table-if-elif-else/90510/4 "2024-05-16T17:13:14Z")

</div>

> [@Ayanakoji](#):
>
> priority=="Low"?"916AAD":priority=="Medium"?"F5E11B":priority=="High"?"EC8629":"E22028"

Try adding '#' to the color values:

`priority=="Low"?"#916AAD":priority=="Medium"?"#F5E11B":priority=="High"?"#EC8629":"#E22028"`

---

<div class="post-metadata">

**Author:** ![Ayanakoji](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@Ayanakoji](https://forum.inductiveautomation.com/u/Ayanakoji)\
**Post date:** [May 16, 2024, 5:16pm UTC](https://forum.inductiveautomation.com/t/row-color-on-report-table-if-elif-else/90510/5 "2024-05-16T17:16:55Z")

</div>

> [@Ryan\_Deardorff](#):
>
> priority=="Low"?"#916AAD":priority=="Medium"?"#F5E11B":priority=="High"?"#EC8629":"#E22028"

thanks but I didn't work

---

<div class="post-metadata">

**Author:** ![Duffanator](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/duffanator/32/3560_2.png) [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\
**Post date:** [May 16, 2024, 6:05pm UTC](https://forum.inductiveautomation.com/t/row-color-on-report-table-if-elif-else/90510/6 "2024-05-16T18:05:06Z")

</div>

Looks like priority is not evaluating to a string, you have to force it. This works:

```python
priority.toString()=="Low"?"#916AAD":priority.toString()=="Medium"?"#F5E11B":priority.toString()=="High"?"#EC8629":"#E22028"

```

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/a/9a59c9e0269dcf64bbcf21dd356ee2791eccb665.png)

---

<div class="post-metadata">

**Author:** ![Ayanakoji](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@Ayanakoji](https://forum.inductiveautomation.com/u/Ayanakoji)\
**Post date:** [May 16, 2024, 10:00pm UTC](https://forum.inductiveautomation.com/t/row-color-on-report-table-if-elif-else/90510/7 "2024-05-16T22:00:12Z")

</div>

Hi! thanks for the solution, i see the problem, yeah the data type of the priority is different.

i hope there will be some data type column in data browser so its much easier to troubleshoot stuff like this hehe