max( )

[9ae6]

Hello,

During the session, I would like to get in my HUD the max of my stack. Then I have tried to use

max(live_cash_player.amt_stack)

but it doesn't works.
How Can I do please?

Best regards,
0n_u

[Flag_Hippo]

I would like to get in my HUD the max of my stack.

You mean you want to display whatever the maximum peak of your stack has been during the session? If so that's not what live_cash_player.amt_stack does - it's the size of your current stack based on the last hand imported.

[9ae6]

Thank you it works If I put

Code: Select all

max(cash_hand_player_statistics.amt_before)

But How to do If I want the max of amt_won during the session?

amt_won is

Code: Select all

sum(cash_hand_player_statistics.amt_won)

then If I want the max of it I tried

Code: Select all

max(sum(cash_hand_player_statistics.amt_won))

but it doesn't works. I have the message that is not a valid SQL

[Flag_Hippo]

You cannot use max and sum together like that and I don't know if such a statistic is even feasible to build.

[9ae6]

Ok thank you I will search another solution