Essentially what the question title says, we have a "Button Dropdown" Component that allows the user to switch between which combination of Dimension and KPI he wants to see.

The KPIs are quite different (# of Days, Invoice Amount in Euros, % of Rework) and therefore require different Formatting and Units.

Formatting example:

This is supposed to provide a Decimal Number of Days, but here is what we're getting:

I have attempted to simply input the formats in a Variable and call that Variable in the KPI Setup, but the resulting Formatting is not making sense! The units work okay, but it's ignoring the space character ("X Days" VS "X Days")

Could you please provide some pointers?

Thank you in advance!

Best Regards,

Vasco Carona