I'm not familiar with the financial formula but I think your formula needs to be (1+ [percent daily change])*(1+PREVIOUS_VALUE([percent daily change]))-1
Let me know if that helped
CrossTab Example.twbx 250.9 KB
But the formula needs the previous value of the same field. Something like self referring itself to its previous value.
TWRR = (1+ [percent daily change])*(1+PREVIOUS_VALUE([TWRR]))-1
Got it. Previous_value(0) or Previous_value(1) works to get the previous value of the same field.
And the NULL error was solved using ZN in the other calculations which makes NULL values change to 0.