Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I wrote this expression to count the customers who have a value greater than 100 for the KI sector
Count( {$<FATT_VEN_AC={">=100"}, FT_SECTOR={"KI"}>} AC_COD_RS)
but the results it provides concern customers who have a value other than 0.
The FATT_VEN_AC measure is defined in master item with the following definition
Sum ( {$< YEAR ={$(=CURRENT_YEAR)}> } FT_AMOUNT)
and AC_COD_RS is the customer code.
can anyone help me?
@Tmassimo
I didn't mention the FT_SECTOR={"KI"} filter in the message above, but I would place it within the master measure.
Sum ({$< YEAR ={$(=CURRENT_YEAR)},FT_SECTOR={"KI"}> } FT_AMOUNT)
And then the count expression.
count(distinct{< AC_COD_RS = {"=FATT_VEN_AC>=100"}>}AC_COD_RS)
greetings!
Thank you Matheus. It works well.
@Tmassimo
Try doing it like the example below:
count(distinct{< AC_COD_RS = {"=FATT_VEN_AC>=100"}>}AC_COD_RS)
Att, Matheus
@Tmassimo
I didn't mention the FT_SECTOR={"KI"} filter in the message above, but I would place it within the master measure.
Sum ({$< YEAR ={$(=CURRENT_YEAR)},FT_SECTOR={"KI"}> } FT_AMOUNT)
And then the count expression.
count(distinct{< AC_COD_RS = {"=FATT_VEN_AC>=100"}>}AC_COD_RS)
greetings!
May be this -
Count( {$<AC_COD_RS = {"=Sum ( {$< YEAR ={$(=CURRENT_YEAR)}> } FT_AMOUNT)>=100"}, FT_SECTOR={"KI"}>} AC_COD_RS)
Thank you Matheus. It works well.