A function usage set analysis in the set analysis

[yunus_emre]

Hi experts,

I'm trying to use set analysis in the set analysis, however, I'm getting an error.

My expression is like this:

=sum({<[Customer] = {"=sum({<Calendar = {">= $(=min(Calendar))"}>} sales_amount) >= 1000000"}>} aggr(sum(sales_amount), [Customer]))

I suppose that the problem is "Calendar = {">= $(=min(Calendar))".

Do you have any idea what correct syntax is?

[swuehl · Accepted solution]

Try a different quote other than double quote for the inner search, like square brackets:

=sum({<[Customer] = {"=sum({<Calendar = {[>= $(=min(Calendar))]}>} sales_amount) >= 1000000"}>} aggr(sum(sales_amount), [Customer]))

[yunus_emre]

It is working, thank you so much