Trying to create a calculated field and I am getting the error message "We found a problem with this formula. Try clicking on the insert function of the formula tab to fix it...."
My field on the pivot table is called type. I am filtering so it only shows the financial period, Revenue and Cost of Sales on the columns. I want a calculated field that shows ='Sales Revenue' - 'Cost of Sales' / 'Sale Revenue'. Seems like it should be simple but it won't let me create it. What am I doing wrong?
My field on the pivot table is called type. I am filtering so it only shows the financial period, Revenue and Cost of Sales on the columns. I want a calculated field that shows ='Sales Revenue' - 'Cost of Sales' / 'Sale Revenue'. Seems like it should be simple but it won't let me create it. What am I doing wrong?