Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Nagaraju_kanna
8 - Asteroid

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
22 - Nova
22 - Nova

Hi @Nagaraju_kanna 

 

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

atcodedog05_0-1633530001121.png

 

Hope this helps : )

Nagaraju_kanna
8 - Asteroid

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
22 - Nova
22 - Nova

Hi @Nagaraju_kanna 

 

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

Nagaraju_kanna
8 - Asteroid

Thank You  atcodedog05

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Nagaraju_kanna 

Cheers and have a nice day!

Labels