Please try Sum(If ColumnA=Columnb then 1 else 0 end)
I think I didnt explain it clearly see below:
Column A Column B Property 1 AAA Property 2 AAA Property 3 BBB Property 4 DDD Property 5 DDD Property 6 DDD Property 7 AAA
I'm a trying to come up with the formula that will count the number of AAA and BBB, so in this case the number would be 4.
Basically my goal is to Group AAA & BBB count them, and divide them by the total number of properties= 4/7 = 57%
I can't download at the moment but I used your sample equation and for some reason im getting the expected closing parenthesis after string 7 ... any ideas?
Sum(If([Deal Stage]="Closed" or [Deal Stage]="On Boarded" then 1 else 0 end))/Count([Property Name])
please try this one
Sum(If [Deal Stage]='Closed' or [Deal Stage]='On Boarded' then 1 else 0 end)/Count([Property Name])
1 of 1 people found this helpful
Trying getting rid of the parenthesis before [Deal Stage] and after end. Looking at Indumon's workbook, he took those parenthesis out (Sum(If [Column B]='AAA' or [Column B]='BBB' then 1 else 0 end)/Count([Column B])).
Thanks so much Indumon, that was it!