1 2 Previous Next 17 Replies Latest reply on Jan 17, 2019 10:30 AM by Joe Oppelt

    How to do recursively defined numbers in Tableau?

    Alex Necakov

      Hello all,

               I am currently working on trying to recreate the attached Excel spreadsheet as a table in Tableau 2018.1 but am running into some problems when trying to implement the same formulas. From my data source, I have the side, shares, price, share balance, and principal but cannot calculate the rest of the columns in Tableau. The three highlighted columns in Excel are the ones giving me trouble in particular. Because these three columns all are dependent on each other and the previous values they held (which is very easy to do in Excel), Tableau throws an error that these three calculated fields are circularly defined and everything just doesn't work. How would I be able to get these fields working in Tableau, and as an extra kicker, be able to do the same table calculation when displaying the data in reverse order.

        1 2 Previous Next