These formula's would aggregate across months if more than one month was in your data. Is it the case that the data is only for a single month? If not, some additional logic would need to be added to utilize only the most recent month.
or one of the many helpful calculation examples here: The specified item was not found.
Welcome to the community forums.
Thanks Patrick -
The data contains multiple months and seems to be showing us what we want. The date field is include in the viz.
Thanks for the additional links too will take a look at those.