SOLVED

Same value in all data table cells

Copper 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
best response confirmed by allyreckerman (Microsoft)
Solution

@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

 

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@PamKurtzmanTX 

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

 

WynHopkins_0-1628154302274.png

 

View solution in original post