Stuck on custom stat

[Mercadiator]

Code: Select all

sum(if[cash_hand_player_statistics.position = 8 AND cash_hand_player_statistics.flg_blind_def_opp AND cash_hand_summary.str_aggressors_p NOT LIKE '89%', 1, 0])

My goal is to:
1) situations where player was in position 8 ( BB )
2) where he had the opportunity to defend his blind during a steal attempt (from CO, BTN, SB )
3) where the stealer was either CO or BTN

I don't see anything wrong with my formula,
but it gives back 0 on every single player while it sometimes should be higher.

Could someone please give me some feedback on what I'm doing wrong?

Note: I know there are easier solutions for this particular situation by using the Fold to LP Steal stat and filtering on position, but I would like to make the "formula-type" of solution, as attempted above. It's also part of my learning process in building stats since I'm new.

[kraada]

I don't see anything wrong with that formula either - are you trying to make a fold or 3bet stat in that spot? Obviously the bit you pasted just gives you how often the player in the BB faced that steal, so you'd need more if you wanted to make a particularly interesting stat.

[Mercadiator]

I think I did something wrong in the "Summary Type" field of the stat, because now I got it to work.

It's still a bit confusing what the difference is between "Format Type" and "Summary Type" and how to define them properly.

But the problem I had in my opening post, has now been fixed.

[kraada]

Format type is how the stat is formatted when it displays the number itself. Summary type is used in the summary line at the bottom of reports. You might want that to show an average or the sum or a count of times something happened - so we need that to be flexible as well.