Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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]))
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]))
It is working, thank you so much