If THEN ELSE in Calculated Fields
Issue #708
resolved
Hi Fidel,
is there a way to use If Then Else constructs in the calcualed number fields?
Comments (5)
-
repo owner -
Account Deactivated reporter I would like to Normalize Story Points based on the team working on the Issue.
If team A is in customfield "team" then 50 * value in customfield "storie points" If team B is in customfield "team" then 25 * value in customfield "storie points"
-
repo owner You should use an expression like this one:
%{ttttt} = "Team A" ? 50 * {ppppp} : (%{ttttt} = "Team B" ? 25 * {ppppp} : {ppppp})
Replacing ttttt with field code for field Team, and ppppp with field code for field Story Points.
-
Account Deactivated reporter - changed status to resolved
-
Account Deactivated reporter thanks
- Log in to comment
Yes, you can use
? :
conditional operator, which uses the following format:<boolean_expression>
?
<then_math_expression>:
<else_math_expression>.Example: Calculated Number Field called "Time to Due Date"
The expression used here is:
where
{00012}
is field code for Due date, and{00057}
is field code for Current date and time.Here we are using
? :
operator for avoiding to do subtraction when Due date is not set.You can tell me your exact requirements and I will help you to implement them.