Displaying currency values in thousands without decimals while using % calculations

[ChrisLauron]

Hi there,

This is probably an easily solved issue, but I couldn't find a solution.

I want to display my currency values in thousands without decimals, while I display percentage calculations like Gross Margin as percentages with one decimal. I know how to display percentage calculations with one decimal. But the issue is that when I change formatting in the "Values" menu under "Visual" to not display any decimals for my thousands "scaled" amounts, it makes all my percentage calculations look like zero because I assume it reads those percentages as decimals.

I've tried creating an "in thousands" row in my data, but that won't work because removing decimals still makes all my % calcs look like zero, and rounding would just mess up my percentage calculations altogether.

Is there a way to do this or is it impossible?

[AndersAano]

Moving this to Q&A, and will follow up there