Forum Discussion
Raffle Ticket Number Generator
Hi, guys! Hope you could help me with this one. Our team was assigned to develop a report for a rewards program for our clients, something like if client has transacted 10 times in a month, they ...
create two calculated columns
Pickup = if( Raffle[Status]="Pick-up",1,0)
Delivered = if(Raffle[Status]="Delivered",1,0)
Create a measure
Tickets = sum(Raffle[Pickup])+ if(sum(Raffle[Pickup])=sum(Raffle[Delivered]),5,0)
As you can see there is an issue in the last row. You want to be more specific when you say " for each month that they have 100% pick-up transactions they earn additional 5 tickets."
what does 100% pick-up mean? what if it is over 100% ?