How to count [Total] where [Year] are in USER...

Arnaud_B · 02-19-2018 04:00 PM

How to count [Total] where [Year] are in USERSETTINGS(Year_Option) ? THX

Arnaud_B

@Aleksi_Alkio

mail ?

Aleksi_Alkio

How about… COUNT(SELECT(TableName[Total],[Year]=USERSETTINGS(Year_Option)))

Arnaud_B

@Aleksi_Alkio That’s i try bur result is always the Count[Total] and not filter with YEAR

Aleksi_Alkio

You can send it to aleksi@1track.com

Arnaud_B

@Aleksi_Alkio THX but it is OK. Praveen Seshadri have look into app and this is the solution:

It is because of a type mismatch.

USerSettings(Year_Option) is an EnumList of base type Text.

[Year] is a column of type Number.

You need to either convert the base type of the EnumList to Number. Or in the expression you can wrap [Annee] by a CONCATENATE()

IN(CONCATENATE([Year]), USERSETTINGS(Year_Option)) works the way you expect

Aleksi_Alkio

I thought that I asked are they the same type;-)

Arnaud_B

@Aleksi_Alkio Yes of course. But for me it was OK, both are number. But one is EnumList and basetype was wrong set.

Aleksi_Alkio

Are they both number fields?

Arnaud_B

Yes

Aleksi_Alkio

Check them both with an simple expression for example in virtual column so you could see which one is not correct. USERSETTINGS(Year_Option) should give you 2018 or something.

Arnaud_B

@Aleksi_Alkio USERSETTINGS(Year_Option) return 2017,2018 it’s OK.

SELECT(Liste[YEAR], True, True) return the same thing 2017,2018 COUNT(Liste[TOTAL]) return number with Total of 8

I try this but return me 0 (zero): COUNT(SELECT(Liste[TOTAL],Liste[YEAR]=USERSETTINGS(Year_Option)))

Aleksi_Alkio

Then try COUNT(SELECT(Liste[TOTAL],IN([YEAR],USERSETTINGS(Year_Option))))

Arnaud_B

Return 0,0,0,0,0,0,0,0 instead of 8

Aleksi_Alkio

What is the account ID and app name so I can check quickly, thanks.

Aleksi_Alkio