# Duplikat **URL:** \ **Category:** Ask for Help\ **Created:** [March 22, 2023, 2:30am UTC](https://community.glideapps.com/t/duplikat/59501 "2023-03-22T02:30:27Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [March 22, 2023, 2:30am UTC](https://community.glideapps.com/t/duplikat/59501/1 "2023-03-22T02:30:27Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d2412bfaf8cffdbf3c6918123bbe18933e55e5b8.png) Hi Guys how to get rid of duplicate numbers? ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [March 22, 2023, 4:03am UTC](https://community.glideapps.com/t/duplikat/59501/2 "2023-03-22T04:03:45Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e8750674b1e8b9778e5d786863f52f700c46b727.png) Wish there was a way to calculate with a > Sum Unique ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 22, 2023, 4:19am UTC](https://community.glideapps.com/t/duplikat/59501/3 "2023-03-22T04:19:29Z")
you can extract unique numbers, and then sum them ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [March 22, 2023, 4:26am UTC](https://community.glideapps.com/t/duplikat/59501/4 "2023-03-22T04:26:58Z")
what is this one? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d39973a71194b076f6ca0d9474464de71a66a6d1.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 22, 2023, 4:27am UTC](https://community.glideapps.com/t/duplikat/59501/5 "2023-03-22T04:27:58Z")
yes, this is the one ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [March 22, 2023, 4:31am UTC](https://community.glideapps.com/t/duplikat/59501/6 "2023-03-22T04:31:56Z")
Thank You @Uzo how do i get the data i want? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b56314f8c84c756ea432bdddce5afd262736a9de.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 22, 2023, 4:36am UTC](https://community.glideapps.com/t/duplikat/59501/7 "2023-03-22T04:36:07Z")
It is a little complicated… First, you have to join all the numbers, then use that unique array column, then split these unique numbers, then sum that split ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [March 22, 2023, 4:48am UTC](https://community.glideapps.com/t/duplikat/59501/8 "2023-03-22T04:48:27Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/7/e7bf27c9036917fef9e3fb0ff879441853c01a6d.png) I’ve arrived here ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/4995c52f8e5ada6246bc793bb81d69f1860f8e17.png) there is no option for summation > [@Uzo](#): > > It is a little complicated… > First, you have to join all the numbers, then use that unique array column, then split these unique numbers, then sum that split ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 22, 2023, 4:53am UTC](https://community.glideapps.com/t/duplikat/59501/9 "2023-03-22T04:53:55Z")
You have to turn that array into rows… and then use sum rollup ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 22, 2023, 4:55am UTC](https://community.glideapps.com/t/duplikat/59501/10 "2023-03-22T04:55:14Z")
Whatever column you are using for Rel toko, you can use that same column to create a single relation back to itself in the same table. Then create a Lookup column that returns the Row ID from the relation. Finally create an IF column that checks if the Row ID for that row matches the Lookup Row ID. If it’s a match, then return the Lookup Ongkir value, else return blank or 0. If done correctly, this will give you a number only once, the first time it appears. The second or third time it appears, it will be blank or zero. Then you can sum that final IF column. This works because a single relation will only find the first match. Both instances of Dapur Bu Yanti will have a single relation that only matches the first instance of Dapur Bu Yanti. So the Lookup RowID will only contain the RowID of the first match. As a result, the IF column will only match on the first instance of Dapur Bu Yanti when comparing the row’s RowID to the Lookup RowID. I would definitely not use the Unique Elements method in this case. It will cause problems in the future if you have two different unrelated rows that happen to have the same number. All of a sudden you would eliminate too many numbers and your sum would be wrong. It may not happen often, but it definitely could happen. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 22, 2023, 4:58am UTC](https://community.glideapps.com/t/duplikat/59501/11 "2023-03-22T04:58:35Z")
He is looking for unique numbers… so what do you mean that it will create a problem? If the other row has a same number, it should not be counted ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [March 22, 2023, 5:46am UTC](https://community.glideapps.com/t/duplikat/59501/12 "2023-03-22T05:46:05Z")
> [@Uzo](#): > > You have to turn that array into rows What type should I use to convert an array into rows? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 22, 2023, 5:47am UTC](https://community.glideapps.com/t/duplikat/59501/13 "2023-03-22T05:47:12Z")
also a bit complicated 😉 I posted this method somewhere many times… let me find it ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 22, 2023, 5:54am UTC](https://community.glideapps.com/t/duplikat/59501/14 "2023-03-22T05:54:12Z")
I can’t find it anymore… so 1. add a row id column 2. add a lookup column and point to that row id 3. add an array index column and find the index of row id in the lookup column that will give you row numbers starting from zero then add a single value column and extract values from your unique numbers, use row numbers as a position of the single value