Great video, ... just a suggestion that you change your RANDBETWEEN formulas to hard coded values (prior to query) so that when we are trying to duplicate your results we can compare and get the same values. I thought I was doing something wrong because my percentage results were not the same as your video; turns out that randbetween was recalculating my values...
Showing what South Africans are made off! Well done man, you're a rock star!
glorious thanks man!
Thanks for the video James. very helpful.
Excellent! What a great explanation of List.Accumulate! Many thanks!
Thanks James. I wonder how many times I'm going to have to view the video before list.accumulate sinks in!
and that's what videos are for 🙂
ye this is probably one of the more counter intuitive functions. vs. looping in python.
When I see a new BA Sensei video, I click!
Awesome as always. Thanks James.
glorious!
Mind blowing🤪
I don't understand half of it but still amazing.
Great video, ... just a suggestion that you change your RANDBETWEEN formulas to hard coded values (prior to query) so that when we are trying to duplicate your results we can compare and get the same values. I thought I was doing something wrong because my percentage results were not the same as your video; turns out that randbetween was recalculating my values...
oh damn! yes i still had the randbetween on!
We need more videos about list.accumlate to train
its one of the more tricky ones but once you get it! it's great!
Percentage is total for each individual cell or total of each column. So column 1 total is 100 and percentage in each cell is of the total? Right?
correct! the total for each portfolio!