Structure Plugin : Bug Fix% Count no good.

[Mukund Iyer Rajamony]

Hi, I am looking to write a custom formula which will actually present the number of bugs fixed to the number of bugs open.

I looked at https://wiki.almworks.com/display/structure040/Advanced+Formula+Configuration

and I am unable to find help to configure a formula that checks for the status of the issue.

I am trying something like this:
WITH total_bugs =
SUM{ IF(itemtype='bug'; 1) } :
WITH open_bugs =
SUM { IF(itemtype='bug'; 1) AND IF(status NOT in ('closed', 'done', 'resolved'))};
IF (total_bugs > 0;
SUM IF(total_bugs-open_bugs/ total_bugs);0)

any pointers will be very useful.

[Egor Tasa [ALM Works] · Accepted solution]

Hi Mukund,

Structure's formula does not currently support IN statement, though we are planning to introduce lists and operations with them in one of the upcoming releases. Currently, you can use MATCH or SEARCH functions, so you can replace 

IF(status NOT in ('closed', 'done', 'resolved')

with

IF(SEARCH(status, "closed,done,resolved")

Note that it can fail if you have statuses for example "resolved" and "not resolved", as it will find resolved in both names, but in common use cases it should work fine.

Regards,
Egor Tasa

ALM Works

[Mukund Iyer Rajamony]

This worked! THank you very much!