If THEN ELSE in Calculated Fields

[Christoph Ritter]

Hi Fidel,

is there a way to use If Then Else constructs in the calcualed number fields?

[Fidel Castro Armario]

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:

{00012} != null ? {00012} - {00057} : null

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.

[Christoph Ritter]

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"

[Fidel Castro Armario]

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.

[Christoph Ritter]

thanks