JIRA基于列值结构变量

Question

我有一个结构，允许我通过基于%的里程碑跟踪来维护挣值。我有展示活动里程碑的专栏(主要基于Action的状态)。我有里程碑专栏。然后，我将%的值关联起来，以根据某个操作所处的里程碑进行汇总。

with weight1 = 0.6:
with weight2 = 0.2:
with weight3 = 0.15:
with weight4 = 0.05:
IF(MATCH(Summary, "*Formal*")=1; (weight1 = 0.2 AND weight2 = 0.4 AND weight3 = 0.0 AND weight4 = 0.4))
AND
IF(MATCH(milestone4; "*Done*"); weight1+weight2+weight3+weight4;
MATCH(milestone3; "*Done*"); weight1+weight2+weight3;
MATCH(milestone2; "*Done*"); weight1+weight2;
MATCH(milestone1; "*Done*");weight1;0)

问题是当摘要有&;formal &;在其中，权重值不会改变。是否有更好的方法来基于里程碑的条件变量值?

Answer 1

在与其他JIRA用户进行了一些交流之后，我们提出了这个问题的解决方案。这只是语法的重新排列，以迫使JIRA使用正确的值。

with weight1 = IF(MATCH(Summary, "*Formal*")=1; 0.2; 0.6):
with weight2 = IF(MATCH(Summary, "*Formal*")=1; 0.4; 0.2):
with weight3 = IF(MATCH(Summary, "*Formal*")=1; 0.0; 0.15):
with weight4 = IF(MATCH(Summary, "*Formal*")=1; 0.4; 0.05):
IF(MATCH(milestone4; "*Done*"); weight1+weight2+weight3+weight4;
MATCH(milestone3; "*Done*"); weight1+weight2+weight3;
MATCH(milestone2; "*Done*"); weight1+weight2;
MATCH(milestone1; "*Done*");weight1;0)

我已经在我的结构中测试了这个，它工作得很好。