Conflict between tempo results and story points

[Ozan Topkaya]

Hallo all

In JQL table filter, I have conflict between story points and tempo information. Depending on the selection of decimal separator (comma or dot) one of them is miscalculated.

decimal separator comma;
Although story points are integers in Jira, they are presented in the table as a decimal number and the sum is calculated incorrectly, whereas tempo information would be correct

decimal separator dot;
Storypoints are totalled correctly but tempo information would be wrong this time

Info:
Confluence V7.19.16
Jira  V8.20.14

Thank you

[Bektas Ozan Topkaya]

Thank you all. I have created a new ticket on App owner Stiltsoft.

[Nicolai Sibler]

Hi @Ozan Topkaya

as the decimal separator can only be set for the whole table (and not column-wise) in the Table Filter Macro settings, you'll probably need some extra to fix this.

I'd suggest to either change one of the Jira field's decimal separator (if possible at all) or open a support ticket @Stiltsoft support (the app vendor), if they don't step in here.

My guess is that it should be possible to re-define one of the column's decimal separator in the Table Transformer Macro (wrapped around the table) but I couldn't point out how due to my poor SQL skills ;-)

Regards,

Nicolai

[Dave Mathijs]

Hi @Ozan Topkaya Which third-party app or custom field are you using to generate those totals in Confluence?

[Bektas Ozan Topkaya]

We are using the system fields of Tempo App.