This content has been marked as final.
Show 2 replies

1. Re: Table Calculations in tableau based on lookup functions
Stephen Rizzo Aug 26, 2016 6:54 AM (in response to dinesh reddy)The formula that you described above doesn't give the numbers in your table  row 3 would be 218, not 461.7. My guess is that something is missing judging from the missing parenthesis.
With that said, what you described can be accomplished with the following calculation:
IF FIRST()==0 THEN 300*(.9) ELSE PREVIOUS_VALUE(1)*(.9) END
I hope that helps!

2. Re: Table Calculations in tableau based on lookup functions
Michael Hesser Aug 26, 2016 7:49 AM (in response to dinesh reddy)1 of 1 people found this helpfulHi Dinesh;
Did you want to make the [Percent] dynamic?
With respects to Stephen Rizzo, this worked for me:
PREVIOUS_VALUE(sum([Balance])) * (1+sum({fixed [New]:sum([Percent])}))
Good luck!