topic SET ANALYSIS in App Development

SET ANALYSIS

Tmassimo — Thu, 11 Jan 2024 17:10:21 GMT

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?

MatheusC — Thu, 11 Jan 2024 17:53:07 GMT

@Tmassimo

Try doing it like the example below:

count(distinct{< AC_COD_RS = {"=FATT_VEN_AC>=100"}>}AC_COD_RS)

Att, Matheus

MatheusC — Thu, 11 Jan 2024 19:18:52 GMT

@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!

Digvijay_Singh — Thu, 11 Jan 2024 20:12:07 GMT

May be this -

Count( {$<AC_COD_RS = {"=Sum ( {$< YEAR ={$(=CURRENT_YEAR)}> } FT_AMOUNT)>=100"}, FT_SECTOR={"KI"}>} AC_COD_RS)

Tmassimo — Thu, 11 Jan 2024 20:28:35 GMT

Thank you Matheus. It works well.