decimal points appear on simple integer addition on table transformer

emagnun

I have a table to track jira task based on their status as below.

The inner table-transformer is to get the numbers properly for each status column. I use split function to retrieve the numbers.  (eg: T1.'To Do'->split(" ")->0 AS 'To Do')

The outer table transformer is to add a total column that sums up each status column. But the output adds decimal points to the total column, i dont know why.

 

I tried to use ROUND(T1.'To Do' + T1.'In Progress' + T1.'Done' AS 'Total',0) as well, but decimal points still there.  Pls help.

 

 

Katerina Kovriga {Stiltsoft}

Hi @emagnun ,

Check the settings of your Table Transformers -> Decimal places. You may have "2" there (if earlier you used macros with this precise settings, the current macro may catch it).