08-15-2011 12:21 PM
I need your help with the following
if first.household_id then large_spending_count = 0;
if total_spent>100 then large_spending_count+1;
basically, I want to count how many purchases with total_spent > 100 dollars were made for each household.
so, i want to make large_spending_count = 0 for each new household. it should increase by 1 each time a purchase (>$100) is made.
somehow, it's not working... (it's my first time using first function but I think I need to use it; if not, let me know as well)
can someone please tell me how this may be done?
Need further help from the community? Please ask a new question.