nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Structure Formula - display colored value of a Variable

Uwe Döll

Hi,

i am calculating a value, that is saved in my variable "diff".

I want to show the value of the variable in structure with a colored background. I tried a lot, but instead of the value i only get the Name of my variable.

Here is a Part of my Formula:

--------------

with diff = X/Y:

IF diff < 0.5:
//$diff{backgroundColor=red color=white}
":panel[diff]{backgroundColor=red color=white}"
//FORMAT_CAPTION("RED", ":cloud_with_lightning_and_rain:" diff)
ELSE IF diff ...

-------------

In the picture you can see some Results. Instead of "diff" i want to se something like "1,54"...

The "Format_Caption" is a copy-paste from the helping sites - which did not help.

Accepted answers

David Niro

Hello @Uwe Döll ,

David from ALM Works here. Welcome to the Community!

Your formula is 99% of the way there. There are two adjustments we can make to get it working for you.

The first is to define diff as an expression using $ and to enclose the Text Snippet with """.

With those two modifications, your formula should look like this:

with diff = X/Y:

IF diff < 0.5:

""":panel[$diff]{backgroundColor=red color=white}"""

Please let me know if this helps!

Best Regards,
David

All comments

David Niro

Hello @Uwe Döll ,

David from ALM Works here. Welcome to the Community!

Your formula is 99% of the way there. There are two adjustments we can make to get it working for you.

The first is to define diff as an expression using $ and to enclose the Text Snippet with """.

With those two modifications, your formula should look like this:

with diff = X/Y:

IF diff < 0.5:

""":panel[$diff]{backgroundColor=red color=white}"""

Please let me know if this helps!

Best Regards,
David

Uwe Döll

Good morning David,

Thanks for your help. It works exactly how i want it to :-)

Best Regards,

Uwe

David Niro

You are very welcome, @Uwe Döll ! So glad to hear it was the right solution for you!

Best,
David

Stavros_4hzoqa

Thanks for the great answer, @David Niro
It´s still helpful, fyi

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

structure

expr

formula