Peek and Previous

[HMUTUAL01]

I am trying to create a dataset which looks back and populate the previous days balance but it doesn't seem to be populating the previous fields. Below is my query.

[JonnyPoole]

So more logic then as the field exists... try adding Fund_Plan_Key as another field in the load by itself.  I checked the docs and your not supposed to have to add it into the load, but at this point I feel the need to just pursue where logic is asking us to go regardless of docs.

And/or try adding [] around the reference to the field ie: [Fund_Plan_Key]

[HMUTUAL01]

I did the following and I think it's working now