Field Wrong Calculations

0 votes

When using an Excel pivot table to examine a dataset, I wanted to add a calculated field that would allow me to determine the profit by dividing the revenue by the budget. I have seen that the field is not operating in accordance with its purported formula; instead, it is adding the data from the raw data while completely ignoring the formula. Please help, I attempted to figure it out but couldn't come up with a solution.

It subducts the cells from the raw data but I want the formula to subduct them using the Averages that I generated..

enter image description here

enter image description here

I attempted to adjust the formula and add "Average" before each column, but it was unsuccessful. There is a Google Sheets option named Custom. which omitted the aggregating processes in favour of the formula. My issue is that the Averages that I am aiming for are not being picked up since, although the formula appears to be functioning, it is utilising cells from the raw data rather than the cells I want to utilise.

Apr 3, 2023 in Others by Kithuzzz
• 38,010 points
331 views

1 answer to this question.

0 votes

You can accomplish your goals in one of two ways:

You should first add a new column to your table called "Dummy," say, with a value of 1 in each row. Next you may use the Calculated Field that is listed below:

='Box Office Revenue ($)' / Dummy - 'Budget ($)' / Dummy

Add your table to the Data Model and use the following measure within Power Pivot:

=AVERAGE ( Table1[Box Office Revenue ($)] ) - AVERAGE ( Table1[Budget ($)] )
answered Apr 3, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

How to create an input field in Flutter?

Hi@akhtar, There are different ways to create an ...READ MORE

answered Aug 9, 2020 in Others by MD
• 95,440 points
1,078 views
0 votes
1 answer

How to retrieve the value of a text field in Flutter App?

Hi@akhtar, In your TextField, you can call one ...READ MORE

answered Sep 3, 2020 in Others by MD
• 95,440 points
1,477 views
0 votes
1 answer

How to merge two cells in excel with same field name

Insert 2 new columns, G & H. Enter ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,420 points
1,099 views
0 votes
1 answer

Excel: Group rows and add minimum and maximum from two different columns within the group

You can accomplish your goal with Power ...READ MORE

answered Dec 19, 2022 in Others by narikkadan
• 63,420 points
573 views
0 votes
1 answer

Excel Pivot Table : Calculated Field ( formula to be used like sumproduct)

With a calculated field, you might not ...READ MORE

answered Jan 3, 2023 in Others by narikkadan
• 63,420 points
1,534 views
0 votes
1 answer
0 votes
1 answer

Pivoting 4x4 into 16x1

Try this: df <- tibble::tribble( ~ID, ~sit1, ...READ MORE

answered Jan 30, 2023 in Others by narikkadan
• 63,420 points
179 views
0 votes
1 answer

How to copy title of WP post dynamically to focus keyword field in Yoast SEO?

$title = get_the_title(); $args = array('posts_per_page' => -1, ...READ MORE

answered Feb 24, 2022 in Others by narikkadan
• 63,420 points
976 views
0 votes
1 answer

Excel If field with rounding

Here's your formula. Assumes your cell containing ...READ MORE

answered Sep 27, 2022 in Others by narikkadan
• 63,420 points
501 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP