Math Calculations by rules

[RJ]

I have a total value box that is using this formula - which works fine - this
is in the value box.

sum(QuantJTS) * sum(RetailValue) * sum(varEquipModifer)

Now I have a rule, set on Condition if Category equals to TBG, the formula
is set like this:

sum(QuantFootage) * sum(RetailValue) * sum(varEquipModifer)

This works fine as well but when the category is picked as TBG, the rules do
not go into effect and does not set the value there. How come. I am not a
programmer and I thought this was a pretty simple function but apparently
doesnt work with rules. Thank you for your time.

 

[RJ]

Thank you for your response but that did not work. THis is in the detail
section of master/details, not sure if that will effect the calculations.