Forum Discussion
Solved
Same value in all data table cells
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.
4 Replies
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!
