Number formating

[NiranjanK1]

Hello All,

I would like to update additional decimal for value inside the string how can I implement below logic.

Mismath(FORMATNUMBER(value,'###0.000000'))

How to implement same.

Regards,

Niranjan 

[binuacs]

@NiranjanK1 I am not sure I understand your requirement properly, based on my understanding I think the amount in your Excel sheet just rounding the numbers into two decimal places, if you open that Excel in Alteryx you will able to see all the digits after the decimal. If this is not something you are looking for then provide some sample data in Excel with output data

[NiranjanK1]

@binuacsHere is the example, Below is the output for im looking

Field1: Mismatch

Field2:    Value =500.032654

Function:Field1+Field

               Mismatch(FORMATNUMBER(500,'###0.000000')

Final Output: 

              Mismatch (500.032654)

The final output (string + value) need additional decimal  

[binuacs]

@NiranjanK1 let me know the below function works for you