Calculated Field in Pivot from Data Model

Hi All,

I just started to work with a Data Model for the first time and have been trying to replicate a calculated field I had in a previous version of my workbook. This was a simple divide calculation to obtain a % of profit from the profit and revenue.

I have added a column to my data model using this formula:

Formula:

Please Login or Register  to view this content.

However when adding this field to the pivot table I can not get it to show the correct Gross Profit percentage for each row on my pivot table. Below is a few examples of what I am seeing:

Revenue Gross Profit GP%
£482,429 £100,696 -3.38%
£77,906 £18,277 -102.25%
£676 -£322 -60.45%

Please can anyone advise how I can accordingly get this to display the correct figure and so that a GP% of 100696 / 482429 will show as 20.87% for example?

Thanks,

Thanks for your advice - I've done that and its solved the problem!!