Creating variable to find previous interest date and use result in set analysis
Hi,
I'm having a hard time figuring out how to implement a variable into my set analysis.
My variables work as expected when putting them in a table using my dimensions %dimSecurities, it all looks fine. I guess my problem could have something to do with use of AGGR
This returns a numbervalue per %dimSecurities in my table
My main variable then check if the prevoius date was a date where the interest were "paid", if not this second variable will look back to get the date before:
Note that I have excluded the '=' in beginning of this variable. Not sure if it makes any difference as I adjust for this when I'm using the variable in my set analysis:
This set analysis returns values, but the values is not coming from the correct dates, it looks like they all have the same date (most likely the oldest date, and somehow seems to be failing on the dimension)