Same value in all data table cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2611509%22%20slang%3D%22en-US%22%3ESame%20value%20in%20all%20data%20table%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2611509%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20setting%20it%20up.%20I%20need%20to%20calculate%20a%20few%20different%20columns%20so%20I%20copied%20the%20table%20and%20tried%20using%20a%20different%20formula.%20Why%20did%20my%20table%20put%20the%20same%20value%20in%20all%20cells%20while%20yours%20(the%2010%20year%20sum)%20worked%3F%20I%20picked%20the%20E18%20for%20the%20row%20input%20and%20E19%20for%20the%20column%20input.%26nbsp%3B%20Note%2C%20I%20also%20tried%20to%20replicate%20yours%20on%20the%20DS%20Comparison%20page%20and%20it%20didn't%20work%20either.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%2Fattachments-key%2F9abcbedc-93e4-4e0f-9ef1-c29cf6df5537%23%22%20target%3D%22_blank%22%3EExcel%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%2Fattachments-key%2F9abcbedc-93e4-4e0f-9ef1-c29cf6df5537%23%22%20target%3D%22_blank%22%3EFormulas%20and%20Functions%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2611509%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-2614224%22%20slang%3D%22en-US%22%3ERe%3A%20Same%20value%20in%20all%20data%20table%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2614224%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1119826%22%20target%3D%22_blank%22%3E%40PamKurtzmanTX%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20input%20cells%20are%20linked%20to%20your%20model%20while%20the%20copy%20you%20made%20are%20not%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WynHopkins_0-1628154302274.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300678i017ED807FEBA3BC5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22WynHopkins_0-1628154302274.png%22%20alt%3D%22WynHopkins_0-1628154302274.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

@Wyn Hopkins

https://techcommunity.microsoft.com/t5/user/viewprofilepage/user-id/9832

 

 

Thanks for setting it up. I need to calculate a few different columns so I copied the table and tried using a different formula. Why did my table put the same value in all cells while yours (the 10 year sum) worked? I picked the E18 for the row input and E19 for the column input.  Note, I also tried to replicate yours on the DS Comparison page and it didn't work either. 

Excel

Formulas and Functions

 

 

4 Replies

@PamKurtzmanTX 

My input cells are linked to your model while the copy you made are not

 

WynHopkins_0-1628154302274.png

 

@Wyn Hopkins 

Got it! I fixed that and it is almost working completely. Yay! However, two lines are calculating the same but no others. Any ideas on how to fix it?

I changed the number in the table and it started working. I am not sure why it wasn't working before but now I have it figured out. Thank you so much for your help. This knowledge will save me hours of work. Now onto the next challenge!

@PamKurtzmanTX 

 

Make sure your calculation is set to Automatic and not Automatic Except for Data Tables

WynHopkins_0-1628206046050.png

 

Glad to help