topic Re: Actually my amount format is - 9999999.99 length 12 but my workflow report result wro in Alteryx Designer Desktop Discussions

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

Nagaraju_kanna — Thu, 13 Jun 2024 21:57:27 GMT

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 — Wed, 06 Oct 2021 14:20:12 GMT

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

Hope this helps : )

Nagaraju_kanna — Thu, 07 Oct 2021 09:50:47 GMT

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 — Thu, 07 Oct 2021 10:16:31 GMT

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

Nagaraju_kanna — Thu, 07 Oct 2021 14:19:40 GMT

Thank You atcodedog05

atcodedog05 — Thu, 07 Oct 2021 14:20:13 GMT

Happy to help : ) @Nagaraju_kanna

Cheers and have a nice day!