Skip to main content

So if the base number is 100 and the annual number is 20 and we're looking out over 5 years, the calculated number would start with 100 and decrease by 20 each year until it gets to zero.

 

Seems like it should be easy by maybe I'm just dumb!

1 respuesta
  1. 14 feb 2025, 12:14

    You are not dumb - just new to tableau - I would use something like

    sum(base) - index()*(sum(base)/ sum({fixed: countd(year))})

    give it a try and when you have other questions ALWAYS post a twbx so we have something to work from

    BTW see video https://www.youtube.com/watch?v=easBRzi9_bk and then the series https://jimdehner.com/bgs-beyond-getting-started-the-path-to-understanding-tableau/ they are FREE and will help transition to tableau