If vRed is defined without an = sign then it should not be calculated at the document level.
To check what is happening, change your chart to a straight table and make the label for the express blank (i.e. it defaults to <use expression>). When the straight table displays, the actual expression that is being used - after the dollar expansion - will be visible and that should help you troubleshoot what is happening.
Thanks for your suggestion, but unfortunately the calculation just appears as if I had written it ‘long hand’.
The way it is calculating the answer is as follows:
- It looks at the data for all periods and calculates how many Employees are <50%, say 10 people.
- It then looks at the specified period and checks how many of those 10 people have data in that period – say 8.
- It will then use the 8 as the numerator and divides it by the number of Distinct employees in that period
Obviously I want it to use the calculated count of employees <50% for the specified period to be the numerator.