Rounding issues based on data type

MHS

Hello Community!

I have a problem that I was hoping that someone could help me with.  I am calculating a ratio thru the multi-row tool  and attempting to export the field as an integer field type, but the tool continues to throw an error that the field resulted in a string but the field is numeric.  I can export the field as a string, but when I change the field type back to an integer with the select tool  I run into a rounding issue with the ratio which does not allow me to convert to a percentage.  Any help or tips would be greatly appreciated.

Thanks, 

Matt

grazitti_sapna

Hi @MHS,

Can you try this expression and let me know if it solves your issue.

IF [Average - Ignore 0's_New open status]>= 1 THEN [Average - Ignore 0's_New open status]/[Row+7:Sum_Consolidated status duration]
ELSEIF [Average - Ignore 0's_Sprint ready duration seconds]>= 1 THEN [Average - Ignore 0's_Sprint ready duration seconds]/[Row+6:Sum_Consolidated status duration]
ELSEIF [Average - Ignore 0's_3 Amigos duration seconds]>= 1 THEN [Average - Ignore 0's_3 Amigos duration seconds]/[Row+5:Sum_Consolidated status duration]
ELSEIF [Average - Ignore 0's_In progress duration seconds]>= 1 THEN [Average - Ignore 0's_In progress duration seconds]/[Row+4:Sum_Consolidated status duration]
ELSEIF [Average - Ignore 0's_Story signoff duration seconds]>= 1 THEN [Average - Ignore 0's_Story signoff duration seconds]/[Row+3:Sum_Consolidated status duration]
ELSEIF [Average - Ignore 0's_Release testing duration seconds]>= 1 THEN [Average - Ignore 0's_Release testing duration seconds]/[Row+2:Sum_Consolidated status duration]
ELSEIF [Average - Ignore 0's_Release ready duration seconds]>= 1 THEN [Average - Ignore 0's_Release ready duration seconds]/[Row+1:Sum_Consolidated status duration]
ELSE null() ENDIF