Alteryx Designer Desktop Discussions

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

How to set zero instead of a repeating value

Neffri
8 - Asteroid

Hi all,

Can I ask you how I can create zero in Amount Due for the same Customer ID?

 

Customer IDAmount DueAmount Order DateOrder IDProduct TypePrice
1515.9880009/05/20237659258A271.3240741
1515.9880027/04/20237659256A672.1111111
1515.9880010/05/20237659259B761.6018519
1515.9880005/05/20237659257C271.3240741
243690.475000015/01/20237659255C976.037037
243690.475000014/12/20227659253A179.212963
243690.475000013/01/20237659251C193.2592593

 

But I would like to have:

 

Customer IDAmount DueAmount Order DateOrder IDProduct TypePrice
1515.9880009/05/20237659258A271.3240741
10027/04/20237659256A672.1111111
10010/05/20237659259B761.6018519
10005/05/20237659257C271.3240741
243690.475000015/01/20237659255C976.037037
20014/12/20227659253A179.212963
20013/01/20237659251C193.2592593

so all values which are duplicates should be 0.

I Will be grateful for support!

0 REPLIES 0
Labels