Forum Discussion
how to replace duplicating values in a column with zero
I'm wanting to create a new column that populates the balance for each CIF key only one time instead of having repeating values. So for CIF Key "O10024", the first row has the balance $5804.84, then the second row for that CIF key is populated with 0. That way, when i put this into a matrix, the balances are not added together for each CIF key. (So the balance only shows as $5804.84 instead of $11609.68).
adkjfhasdf12440 The easier option might be to just use AVERAGE instead of SUM. Otherwise, you will need an Index and have to jump through a bunch of PQ hoops. If you can post the sample data as text it will be easier to help.
4 Replies
- Greg_Deckler
Community Champion
adkjfhasdf12440 The easier option might be to just use AVERAGE instead of SUM. Otherwise, you will need an Index and have to jump through a bunch of PQ hoops. If you can post the sample data as text it will be easier to help.
v-saisrao-msftCommunity Support
Hi adkjfhasdf12440,
I wanted to check if you had the opportunity to review the information provided by Greg_Deckler. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.- v-saisrao-msft
Hi adkjfhasdf12440,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
- v-saisrao-msft
Hi adkjfhasdf12440,
We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.
Thank you.