Solved: What is so peculiar with the number 10? - Page 2

Gerard_Chevalie · 02-26-2023 01:31 AM

Hi,

In a table, I have this formula for a virtual column :

SUM(SELECT(E_Entrées_Coll[Nombre], AND([Nom/couleur]=[_THISROW].[Nom/couleur],[Dimensions]="15x15"),TRUE)

This is what happens: in the column [Nombre] of the table E_Entrées_Coll, when the value of a cell is 10, the value seems to be ignored and is not integrated in the SUM result. When the value is 1 or 9 or 11 or 20, the sum is correctly done.

Any idea of the cause of this strange phenomenon?

Thanks in advance for your help

Gérard

Gerard_Chevalie

OK, got it !

With the TRUE parameter, the app considered 10 as a duplicate to be ignored...

Thanks a lot for having opened my eyes on this !

Gérard

View solution in original post