I have a choice field with various grant award amounts (1000, 2500, 5000, 0-decline). I’ve created a global composite to sum the award for all applications we receive - this is working ok.
I’d now like to do conditional formatting on it, so if the sum of all awards is less than £1m it is green, then another for amber and another for red.
When I try to create the subset it won’t let me put an amount in the value box, it just says ‘please select’. I have a feeling it is because of the 0-decline option in the field the composite is based on, however this isn’t stopping the composite working, so not sure why it should be an issue in the subset.