Page 1 of 1

value expression not working

PostPosted: Sun Oct 24, 2021 3:17 am
by DJSpinThat
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?

Re: value expression not working

PostPosted: Sun Oct 24, 2021 2:30 pm
by Flag_Hippo
I get the expected result of 20 with the exact same formula and your quoted numbers:

djspin.PNG
(23.18 KiB) Downloaded 656 times

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.

Re: value expression not working

PostPosted: Mon Oct 25, 2021 4:32 am
by DJSpinThat
"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.