Reports - Column Average

[PJs Ronin]

This is a report I have in PT3:

Screenshot-2.png

(51.68 KiB) Downloaded 1482 times

I have created a similar report in PT4, but how do I get the All-in EQ column to average?

Screenshot-1.png

(76.93 KiB) Downloaded 1465 times

[WhiteRider]

Click the blue "Advanced" link on the left and enable the "Has Summary" option.

[PJs Ronin]

The 'has summary' box was already checked.

[WhiteRider]

Sorry, I misread your post. :oops:

Because all-in equity will be blank for most hands the summary won't make sense in most reports so is blank. You could make a copy of the stat and change the Summary Expression to display the average value for this kind of case if you like.

[PJs Ronin]

The stat All-in Equity is based on the blue variable (blue meaning user defined, right?) val_allin_equity which has a Summary Type of 'average'. So I am at a lost to see why this report column is not 'averaged' at the bottom.

[WhiteRider]

It is because the Summary Expression in the Stat itself is set to empty text (' '). You will need to change the expression there - changing it to "same as format" should be good enough in this case.

2012-01-10 08h48_21.png

(62.1 KiB) Downloaded 1426 times

[PJs Ronin]

I think I've found the problem.

It seems that during the PT4 install, or perhaps after that when I imported some reports, some of my old user defined stats from PT3 were incorporated into PT4. The Allin Equity stat I was trying to 'average' was based on a stat/variable called val_allin_equity (the blue variable in my post above), however there was a defined column in PT4 also called val_allin_equity. I could not change the parameters of the blue val_allin_equity because PT4 was telling me something like "can't name a stat/variable same as column". This column had a summary type of 'sum' and that was being reflected in every report I created with the All In Equity stat.

Solution was to delete spurious blue val_allin_equity and duplicate the val_allin_equity column and set summary type to 'average'. I could then rebuild/duplicate the All in Equity stat and everything now works as it should.

Note to developers. Seems PT4 was happy to allow the conflict between the column and the user variable to exist, so long as I didn't change anything.

[WhiteRider]

OK, I see that - it looks like you can import columns or variables with the same name as an existing one, although you can't add one or change and re-save one. I will report this to the development team.