Custom BB Amount not showing summation in summary line

[o0Q0o]

Attempting to create a custom column in a hand report. I've been able to create the custom stat successfully. Added the custom stat to a report successfully.

Need help with the summary line.

At the bottom of most reports is a summary line. For example, Hand # lists unique hand number in each row. The summary line provides a count of the hands.

Another example is BB Won. Each won shows the BB amount won or lost. The summary row shows the summation of the BB amounts won or lost.

My custom column shows BB Won for non-showdown amounts only. How do I get the summary row to show the summation of the BB amounts won or lost?

Thank you.

[Flag_Hippo]

You can format the output of the summary line using the 'Summary Type:' field for your custom statistic although you may need to create a new custom column to sum the amount for those hands - see this thread.

[o0Q0o]

Would you please provide additional guidance?

The example your reference seems to have created some custom columns. I have not created any custom columns. You mention duplicating the existing columns.

I have only created a custom stat. So I don't know what columns I should duplicate to follow your example.

I've included a screenshot of what I have so far. It works for the individual rows in the report, but not the summary.

What do you recommend as my next step(s)?

Thank you.

[Flag_Hippo]

You need to create a custom column that sums the total amount of bb won in that spot using sum(if[, 1, 0]) instead of just (if[, 1, 0]). You can then reference that column in the ''Summary Type:' field for your custom statistic.

[o0Q0o]

Thank you for the additional help.

The custom column and stat both appear to work. Testing the validation for each SQL statement returned positive results.

Unfortunately, adding the new stat to a report produces an error. Attached you'll find a screen shot.

What do you recommend next? Should we open a support request with tech support?

[Flag_Hippo]

I created a different version for you:

BB Won NSD.zip

(406 Bytes) Downloaded 118 times

[o0Q0o]

The custom stat you provided works beautifully. Thank you so much.

Noticed your version did not include sum(if[expression,1,0]). Does the Sum operator get added by selecting Sum in the Summary for the custom column amt_bb_won_nsd?

If the summary line in the report uses the Summary created in the Columns, what purpose does the Summary in the Stats serve?

[Flag_Hippo]

Noticed your version did not include sum(if[expression,1,0]). Does the Sum operator get added by selecting Sum in the Summary for the custom column amt_bb_won_nsd?

Yes.

If the summary line in the report uses the Summary created in the Columns, what purpose does the Summary in the Stats serve?

Where a different format is required or a reference to another column is needed as per the example I linked you to earlier where the hand statistic is a checkbox but a value was desired on the summary line. While you built a custom statistic that worked for each hand you never had a column that summed the amount of BB won in non showdown pots.

[o0Q0o]

Thank you for your time and responses.

Have been enjoying PokerTracker. Creating custom stats and reports provides wonderful insight and is fun too. Have been reading the tutorials y'all have placed online. Still needed the help you provided to create the latest custom stat.

Appreciate the fast response times. Thank you.