I require flag(1,0) , when customers sales have greater than 1500 than 1 or 0, I creating and using list box using below script, but I need into load script , no need to list box or text box.
=if (Aggr(Sum(Sales_Amt),Customer,Sal_Person )>=1500,1,0)
i am seem to be looking like,
Load if (Aggr(sum(Sales_Amt),Customer,Sal_Person )>=1500,1,0) as flag residential sal_ord;
This will add the flag to the transaction table (modify to fit your data model and requiremments):
If(Sum(Value) > 1500, 1, 0) As Flag
GROUP BY Customer, SalesPerson
Thanks for your answer . this exactly(correct answer) i am looking
I have small misunderstanding,
Now here, what is the difference between into AGGR and Group by <Column Name>.