I have several metric types (say type 1, 2, 3) that are numbers (totals of different items). I would like to take the 2nd metric type and say that its target is 10% of type 1, tolerance is 12% of type 1. When I try to build a new metric type and define in the expression builder ([PO],[VALUE_TYPE].Actual) * .1, I receive an error saying the field contains characters that are not valid and it blows up at the * .1, I’m not understanding why. If you look at the available components, * or the times sign is an available (and therefore valid) component.
Any ideas? Thanks,