hi,
I want to create an identification formula,
One Calculated number field (ID:12002) is created and works well.
I want to convert the value into text as
if value is null then null
if value >4 then "Over 4 wks"
if value >2 then "2~4 wks"
if value >0 then "0~2 wks"
I tried to use below 2 method, but failed
<!-- @@Formula:
Integer i = issue.get("customfield_12002");
if (i==null) return null;
if (i > 4) return "Over 4 wks";
if (i > 2) return "2~4 wks";
return "0~2 wks";
-->
or
<!-- @@Formula:
Integer i = issue.get("customfield_12002");
if (i==null) return null;
else if (i > 4) return "Over 4 wks";
else if (i > 2) return "2~4 wks";
else return "0~2 wks";
-->
I refered document as below, however, it doesn't work, please help, thank you,
Quick reply, before you post your question on Answers:
I assume you already have a calculated number field. Let's say its ID is 12345, hence its name is "customfield_12345".
In your Calculated Text Field, you would do something like:
<!-- @@Formula: Integer i = issue. get ( "customfield_12345" ); if (i== null ) return null ; if (i== 0 ) return "low" ; if (i== 2 || i== 3 ) return "medium" ; return "high" ; --> |
I modified the code as below, then it works
<!-- @@Formula:
if (issue.get("customfield_12002")==null) return null;
else if (issue.get("customfield_12002") > 4) return "Over 4 wks";
else if (issue.get("customfield_12002") > 2) return "2~4 wks";
else return "0~2 wks";
-->
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
David Fischer