Non showdown winnings in reports

[Nite]

yes, you are right.
Using the filter "Actions and Opportunities -> River -> Saw Showdown", i get 0$ in the custom stat "W$woSD", and the correct value if i set the same filter to NOT.
So i guess the stat is working correctly, problem fixed.

What if i want create the same statistic but for hands report (amount won without showdown for each hand) ? I've tried to use the same expression in a new "hand" statistic, but it doesn't work (the report shows an error)

Thanks to everyone

[kraada]

You just want to use:

if[ cash_hand_player_statistics.flg_showdown is false, cash_hand_player_statistics.amt_won, 0 ]

Since it's for individual hands you don't need to sum anything up.

[Nite]

You just want to use:

if[ cash_hand_player_statistics.flg_showdown is false, cash_hand_player_statistics.amt_won, 0 ]

Since it's for individual hands you don't need to sum anything up.

Perfect, works !

Thanks.

[thomase]

I made the custom stat w$wosd based on the above pointers. However theres a slight difference between the amount in reports and the red line in the Graph. Could this be because the custom stat is not converted to my Currency?

I'm just looking for a stat in my reports like HEM w$wosd or the red line in PT's graphs.
Please advice,
Thanks.

[kraada]

If you're comparing it to a graph that uses your currency that would definitely explain the discrepancy if you're playing in multiple currencies.

To change it to a My Currency version use this instead for the Player side:

sum(if[ not(cash_hand_player_statistics.flg_showdown), CAST( (cash_hand_player_statistics.val_curr_conv * cash_hand_player_statistics.amt_won) AS numeric ), 0])

and for the Hand side remove the sum() bit.

[thomase]

thanks, it works

[spee__]

I have some trouble with this report stat.

I am playing 6max cash. And in the summary line, i can see a number 6. I tried to figure it out how to fix the summary line, but i couldn't do it. Can i get some help?

[WhiteRider]

The data displayed in the summary line is determined by the Summary Type(s) of the column(s) used. Where you're adding things up and you want the summary to be a total then the Summary Type of the columns used should be set to "Sum". It sounds like you may have it set to "count" or something.

[spee__]

Thank you, I tried to do it at the statistic section the summary not at the columns, it works now !