Data Table - Calculation Error

%3CLINGO-SUB%20id%3D%22lingo-sub-1817668%22%20slang%3D%22en-US%22%3EData%20Table%20-%20Calculation%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1817668%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20made%20a%20data%20table%20which%20references%20a%20different%20input%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20of%20the%20variables%20of%20the%20data%20table%20is%20the%20original%20value%20from%20the%20input%20sheet.%20However%2C%20when%20the%20specific%20variable%20is%20calculated%20in%20the%20data%20table%2C%20the%20resultant%20calculation%20is%20wrong%20-%20This%20is%20highlighted%20in%20red.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SustainableWombat_0-1603703495837.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229210iBA176EC18CFE21A1%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SustainableWombat_0-1603703495837.png%22%20alt%3D%22SustainableWombat_0-1603703495837.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ELogically%2C%20the%20Margin%20cell%20highlighted%20in%20red%20should%20be%200.5%20instead%20of%200.45.%20May%20i%20know%20whats%20the%20error%20made%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasic%20Assumtions%20Below%3A%3C%2FP%3E%3CP%3ERevenue%20%3D%20100%3C%2FP%3E%3CP%3EProfit%20%3D%2050%3C%2FP%3E%3CP%3EMargin%20%3D%2050%2F100%20%3D%2050%25%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1817668%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1818041%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Table%20-%20Calculation%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1818041%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F845743%22%20target%3D%22_blank%22%3E%40SustainableWombat%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20think%20you%20made%20it%20too%20complicated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1819092%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Table%20-%20Calculation%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1819092%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20helping%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20understand%20that%20placing%20them%20in%20the%20same%20sheet%20simplifies%20the%20data%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20even%20after%20combining%20them%20into%20one%20sheet%2C%20i%20still%20get%20erroneous%20values%20as%20seen%20in%20the%20attached%20file.%20I%20don't%20understand%20why%20i%20am%20still%20getting%20the%20wrong%20values%20despite%20modifying%20to%20the%20sample%20template%20as%20you%20did%20before.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1820175%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Table%20-%20Calculation%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1820175%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F845743%22%20target%3D%22_blank%22%3E%40SustainableWombat%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECell%20B2%20should%20not%20contain%20a%20formula.%20Just%20enter%2050%20in%20this%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello All, 

 

I had made a data table which references a different input sheet. 

 

One of the variables of the data table is the original value from the input sheet. However, when the specific variable is calculated in the data table, the resultant calculation is wrong - This is highlighted in red.

SustainableWombat_0-1603703495837.png

Logically, the Margin cell highlighted in red should be 0.5 instead of 0.45. May i know whats the error made?

 

 

Basic Assumtions Below:

Revenue = 100

Profit = 50

Margin = 50/100 = 50%

 

4 Replies

@SustainableWombat 

I think you made it too complicated.

@Hans Vogelaar 

 

Thanks for helping

 

I understand that placing them in the same sheet simplifies the data table.

 

However, even after combining them into one sheet, i still get erroneous values as seen in the attached file. I don't understand why i am still getting the wrong values despite modifying to the sample template as you did before.

@SustainableWombat 

Cell B2 should not contain a formula. Just enter 50 in this cell.

Understood and solved! Thanks for the help!