We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.
SOLVED

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

Nagaraju_kanna
5 - Atom

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.

 

5 REPLIES 5
atcodedog05
20 - Arcturus

Hi @Nagaraju_kanna 

 

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

atcodedog05_0-1633530001121.png

 

Hope this helps : )

Nagaraju_kanna
5 - Atom

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.

Nagaraju_kanna_0-1633600237986.png

 

atcodedog05
20 - Arcturus

Hi @Nagaraju_kanna 

 

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

Nagaraju_kanna
5 - Atom

Thank You  atcodedog05

atcodedog05
20 - Arcturus

Happy to help : ) @Nagaraju_kanna 

Cheers and have a nice day!