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; } } }

Multiplying lookupissue values

Ari Raatikainen

Hi,

In automation I am trying to calculate sum of multiply of two lookupissue values (X and Y)

lookupissue.valueX (string)

lookupissue.valueY (number)

Could you help me and propose what is the correct smartvalue to be used or how to achieve the expected. Take an examle of lookup issue values

5 * 2 + 10 * 3 + 1 * 5 = 10 + 30 + 5 = 45

but if I use for example

{#=}}{{lookupIssues.valueX.asNumber.multiply(lookupIssues.valueY).sum}}{{/}}

it returns 0 ?

Accepted answers

Vishal Biyani_2pr07j

@Ari Raatikainen

if I understand it correct, you want to do sumproduct. Below works.,

{{#=}} {{#lookupIssues}} {{valueY.multiply(valueX.asNumber)}} {{^last}}+ {{/}} {{/}} {{/}}

Can you check and see if this works for you?

All comments

Vishal Biyani_2pr07j

@Ari Raatikainen

if I understand it correct, you want to do sumproduct. Below works.,

{{#=}} {{#lookupIssues}} {{valueY.multiply(valueX.asNumber)}} {{^last}}+ {{/}} {{/}} {{/}}

Can you check and see if this works for you?

Vishal Biyani_2pr07j

@Ari Raatikainen

This will give the correct sum product.

{{#=}} {{#lookupIssues}} {{valueY}} * {{valueX.asNumber}} {{^last}}+ {{/}} {{/}} {{/}}

Ari Raatikainen

Hi @Vishal Biyani your solution works I am so glad to see this finally working - thanks a lot for you help and have a nice day!!

BR;
/Ari

Vishal Biyani_2pr07j

Glad to know this worked for you

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-cloud

calculation

smart-value