Display percent variance as Summary Number while using Period-over-Period card
Has anyone come up with a way to display the variance shown on a period-over-period card as a field for the summary number?
I've got a card which displays our attendance this year-to-date compared to last year-to-date. While the variance is displayed on the card, the CEO wants the variance also shown as a summary number.
I've tried many of the other solutions I've found either here in the Dojo or in the KB, but while the formula will validate in beast mode, it does not appear to actually produce anything. I am interpreting "not appear to actually produce anything" by the zero (including decimals) I see in the summary number.
Of note with one proposed solution I found here in the dojo, other users speculated that the calcuation wasn't working due to the time period being selected as "Year to Date, by Year."
In any case, just curious if anyone has solved this for one of their cards, and if so, would you share how you got it to work with the community?