why is there a duplicate value?
why does it seem like the one field is showing duplicates (within 50 miles) ? why would that be when the drop-down to filter the values only shows one ?

[[image]](https://forum.enterprisedna.co/uploads/db7134/original/2x/f/f4b3b27f40b1ce117481d1c76d47f541dc528eb6.png "image.png")

[image]

***** please disregard, i figured it out. there was a sort column in the data that was not being updated for some of values**.
[image] mbraun:

****** please disregard, i figured it out. there was a sort column in the data that was not being updated for some of values*** .

yep. if you would want to filter those out from the actual report you would do that in power query.

nick

[[enterprise%20dna%20expert%20-%20small]](https://enterprisedna.co/enterprise-dna-experts/)
welcome to mrexcel!

it actually works for me (see below). this appears to be a kind of rounding error. the way excel stores numbers causes some issues when you have decimals. it is a bit rare when comparing a cell to itself, but it can happen. you can try to use sumproduct instead, see column h.

efgh1valuescountifranksumproduct248737.76222336113.11333454287.76111f2:f4f2=countif($e$2:$e$4,">"&e2)+1g2:g4g2=rank.eq(e2,$e$2:$e$4)h2:h4h2=sumproduct(--(round($e$2:$e$4,2)>round(e2,2)))+1 hello [@saurabhgupta](/u/saurabhgupta) :wave:

i’m afraid that the last updated column isn’t supported by our api at this time. this is because it’s calculated client side. you can see a list of these column types here - <https://monday.com/developers/v2#column-values-section-auto-calculated-column>

although the api do… i've seen this as well. it happened to me when i allowed evernote access to selected photos vs all photos. it is a new ios 14 feature. but it keeps asking. in fairness, i have seen this with other apps too though, so not sure if this is an ios 14 bug or the devs aren't 100% sure how to use the new feature.
 


 for me the fix was to go into iphone privacy settings and give evernote access to all photos, then go back in and deny access. but if you try to import photos again and give it selected access this loop will happen again, so if you do it frequently, give evernote access to all photos. that was all you could do with ios 13 and earlier anyway. because each time fill() is invoked it is only applying 0.047% opacity over what was previously drawn. draw() runs aprox 60 times per second … simple answer. no two nodes ever store the same data. instead storj uses erasure coding for which each piece is unique. so piece id’s are unique across the network.

maybe if a piece is lost and then subsequently rebuilt in a repair action it ends up having the same name on the new node. it would de… unfortunately that's not how it works. it's db mapping, and we're talking about joined-tables hierarchy. so the "other side" of the association must be in the referenced table (the detail one, not custom detail). A segmentation fault in this case probably means you accessed one of the arrays out of bounds. Start up a debugger and keep a watch on your indices. hi sheeeng.  thank you for reporting this to us.  we looked into that file and verified that there is a false detection indeed.  we have fixed this already and the fix should go out soon on the next database releases.

 

thank you again for you report! 

 

 

f-secure labs see [creating feedback loops](https://vvvv.org/documentation/creating-feedback-loops).

it’s only the subtype of a datatype. don’t worry about that.

fyi: create an [asstring (value)](https://vvvv.org/documentation/asstring-(value)) and check its sub type for possible subtypes of the datatype “value” Hi  

This is simple. First check whether you are able to connect Sql Server through SSMS or not.If you are able to connect through SSMS, then there may be a problem in connection string. If you are not able to connect through SSMS, then you had some problem with SQL Environment.