Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Statistics Table with the following columns:
- Sales (Currency). It contains the following expression:
num
(Sum (Sales*CurrencyChange),CurrencyFormat)
- Marketing Budget (Number). RELATIVE field (%)
My problem is that when RELATIVE checkbox is selected for Marketing Budget, CurrencyFormat is not correctly displayed. Otherwise it works perfectly.Why the Relative attribute causes this behaviour in another field? How to fix it?
Thanks in advance!
Can you upload the file?
I didn't faced that scenario
I have uploaded a dummy example where you can see this behaviour .. Any hint?
That is weird. I think that's a bug. As a workaround you could use Sum(marketingBudget)/Sum(total marketingBudget) instead of using the relative option and format it as a percentage.