+ Reply to Thread
Results 1 to 5 of 5

Problem with Calculated field

  1. #1
    Forum Contributor
    Join Date
    11-28-2022
    Location
    CANADA
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    149

    Problem with Calculated field

    Hello, Folks,

    I want to simple divide one field to another but it is giving me wrong answer not sure why. I tried different ways but still problem remain same.
    If anyone know pls do let me know.

    Sample file is attached.

    Thanks
    Attached Files Attached Files
    Last edited by AMJADMemon; 06-02-2023 at 01:54 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: Problem with Calculated field

    Cannot manipulate data in a picture. Upload a sample file that is representative of your issue. No more than 8-10 records. Then manually mock up what your solution should look like.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    11-28-2022
    Location
    CANADA
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    149

    Re: Problem with Calculated field

    Here is the attached file.
    I highlighted in yellow the calculated file and expected answer.

    Thanks
    Attached Files Attached Files

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: Problem with Calculated field

    Instead of doing your calculated fields in a regular pivot table, load your data to the data model and make your calculations in Power Pivot. It is much more straight forward.

  5. #5
    Forum Contributor
    Join Date
    11-28-2022
    Location
    CANADA
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    149

    Re: Problem with Calculated field

    Thanks, I totally formatted about this.
    Solved now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Countif Calculated field Excel problem
    By emina002 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-18-2021, 08:31 PM
  2. Problem with a calculated field in Pivot
    By jf102076 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-12-2019, 04:21 PM
  3. Replies: 0
    Last Post: 10-24-2013, 10:59 AM
  4. [SOLVED] Calculated Field Problem in Pivot Table
    By CM_Marsh in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-16-2013, 09:10 AM
  5. [SOLVED] calculated field problem with subtracting
    By skinpup in forum Excel General
    Replies: 21
    Last Post: 12-22-2012, 04:27 PM
  6. Pivot Calculated Field Problem
    By B Glass in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2012, 11:29 AM
  7. PivotTable - Calculated Field Problem...
    By Sabotage1945 in forum Excel General
    Replies: 0
    Last Post: 02-17-2005, 12:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1