Hello, can any one suggest me how to use the below highlighted formula in Alteryx.
Gross Amount | Formula | Out put |
$4,246,218.52 | a2*0.0008 | 3,397 |
$5,405,086.81 | b2*0.0008 | 4,324 |
Solved! Go to Solution.
Hi @Narresh4ut
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
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.52 | a2*0.0009 | 3,397 |
$5,405,086.81 | b2*0.0009 | 4,324 |
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.
Hi @Narresh4ut
Can you check this one
Output:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
@Narresh4ut
Just add the thousands separator based on the workflow of @atcodedog05