Opportunity Amount is Multiplied by 1,000,000
I'm using Power BI via API to pull reporting data from the Twenty-hosted Postgre DB. The Opportunities Amount figure, when viewed in Power BI, is multiplied by 1,000,000. For example: I have a $100,000 opportunity in Twenty; my Power BI report reflects the figure as $100,000,000,000.
I could transform all figures that come from this column in Power BI by dividing by 1,000,000 but I'd prefer to just get it direct.
Any considerations for what I'm missing?
2 Replies