I have the formula below.
(SUM(r.t30s15 for r in $group if( AND( r.Dup == False, r.Remove == False, r.Time <=11.3, r.w_Fav == True, r.w_MACV == True ) ) ))
It works fine as it’s written, but I would like to be able to change out the “group”
I have a GlobalVars table where I want to store the group to be use.
As an example, I have a “t30s15” group and a “t30s30” group.
I’d like to substitute the hard coded t30s15 with a variable from the GlobalVars table where I can change it in the GlobalVars table from t30s15 to t30s30 and it changes all the formulas on my card
here is an example of all the formulas that use
I tried replacing r.t30s15 with “return GlobalVars.lookupOne().CalcATM”. that gave me an error
I tried “GlobalVars.lookupOne().CalcATM”. that made the field 0.
I’m sure this is doable, but my python knowledge is lacking
thanks for the help