Hi,
I've built a set expression in a straight table that combines the results of two flags in the script.
If(Customer='A',Y,N) as CusFlag
From CustomerTable;
And
If(count(CustomerSales>3,Y,N) as CountFlag
From FactTable;
I know the syntax is simplified but hope you get the idea.
Now I'd like two combine those two flags in the script so that I don't have to build a union expression in set analysis. I'd like to have
a flag that says:
FlagTotal Yes/No in the application where Yes combines the results of CusFlag and CountFlag.
