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

Formula

Narresh4ut
6 - Meteoroid

Hello, can any one suggest me how to use the below highlighted formula in Alteryx. 

 

 Gross Amount Formula Out put 
$4,246,218.52a2*0.0008     3,397
$5,405,086.81b2*0.0008     4,324
7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @Narresh4ut 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1605179392552.png

 

Workflow:

atcodedog05_1-1605179296201.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Narresh4ut
6 - Meteoroid

Thanks for the solution and sorry for confusion. but i am using formula on Gross amount which is "$426218.52*0.0009" to get the out put 3,397.

 

 

 Gross Amount Formula Out put 
$4,246,218.52a2*0.0009     3,397
$5,405,086.81b2*0.0009     4,324
atcodedog05
22 - Nova
22 - Nova

Hi @Narresh4ut 

 

It is working on Gross Amount only based on your calculation.

 

Numbers with currency sign and comma are considered as string. It needs to be converted to number by removing this characters.

 

Let me know if you have more concerns.

atcodedog05
22 - Nova
22 - Nova

Hi @Narresh4ut 

 

Can you check this one

Output:

atcodedog05_0-1605180493831.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

messi007
15 - Aurora
15 - Aurora

Dear @Narresh4ut,

 

Please see below:

Attached the workflow 🙂

messi007_0-1605180575428.png

 

Hope that helps !

 

Regards

 

Qiu
20 - Arcturus
20 - Arcturus

@Narresh4ut 
Just add the thousands separator based on the workflow of @atcodedog05 

Capture12.PNG

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @Narresh4ut 

 

Cheers and Happy Analyzing 😀

Labels