Actually my amount format is - 9999999.99 length 12 but my workflow report result wrong

[Nagaraju_kanna]

My Requirement : If amount is 0 display one report and if amount is 1234.34 generate another report.

I written formula like 

IF [Amount] == 0 or [Amount] == Null()
THEN 0
ELSE [Amount]
ENDIF

Output is 

0 amount report is correct

1245 is generating is wrong. I need like 1234.45

Please find the attached my workflow.

[atcodedog05 · Accepted solution]

Hi @Nagaraju_kanna 

Please decimal places in the table tool in the highlighted option below.

Hope this helps : )

[Nagaraju_kanna · Accepted solution]

Hi atcodedog05,

Thank you working fine.

I seen in results for example 12,345.67

I no need in commas in output. 

Please find the attached screen shot.

[atcodedog05 · Accepted solution]

Hi @Nagaraju_kanna 

The comma is fixed formatting for number display it cannot be changed.

[Nagaraju_kanna]

Thank You  atcodedog05

[atcodedog05]

Happy to help : ) @Nagaraju_kanna 

Cheers and have a nice day!