value expression not working

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

value expression not working

Postby DJSpinThat » Sun Oct 24, 2021 3:17 am

In the value expression window i have

100 - (((cnt_steal_att_SB / cnt_steal_opp_SB) + (cnt_p_limp / cnt_p_limp_opp_SB))* 100)

The value of:
(cnt_steal_att_SB / cnt_steal_opp_SB) = 57
(cnt_p_limp / cnt_p_limp_opp_SB) = 23

i should be getting the value 20, but im getting 43, which is just 100 - 57.

can it not understand 100-57-23?
DJSpinThat
 
Posts: 70
Joined: Mon Aug 18, 2014 5:49 pm

Re: value expression not working

Postby Flag_Hippo » Sun Oct 24, 2021 2:30 pm

I get the expected result of 20 with the exact same formula and your quoted numbers:

djspin.PNG

If you've made a bunch of changes to custom columns then you should always rebuild your custom database cache (Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild).

Also for some reason you are using the built-in column cnt_p_limp here (limps from all positions) but all your other columns appear to be for the SB position only.
Flag_Hippo
Moderator
 
Posts: 14443
Joined: Tue Jan 31, 2012 7:50 am

Re: value expression not working

Postby DJSpinThat » Mon Oct 25, 2021 4:32 am

"If you've made a bunch of changes to custom columns then you should always rebuild your custom database cache"

Didn't know about this. Good to know. Thank you.
DJSpinThat
 
Posts: 70
Joined: Mon Aug 18, 2014 5:49 pm


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: sky44 and 13 guests

cron
highfalutin