Is there a 'paste values' or something equivalent in Designer? I have a calculated column in the detail band that gives a count based on a percentage, but since you cannot sum percentages - or do any aggregations with percentages - I am at a loss as to how to show just the sum of the count in the footer.
For example, the pink number below should be 2 instead of 3 -
To get into the weeds, the formula in the CNT column is this -
[Employee Effective From: # Distinct Employee Key]*(SavedExpression('AA Minority Goals')/100)
and the SavedExpression 'AA Minority Goals' is this -
Thank you,
Lisa