Skip to main content
Topics#Tableau Desktop & Web AuthoringFrage von Ratna Sari
Ratna Sari fragte in #Tableau Desktop & Web Authoring
22. Apr. 2018, 04:51

How to get the final value based on center period and %growth in tableau

Hi,

 

I have this scenario, there are 3 parameters in my tableau workbook for user to change the value  

I have data source like this:

 

My Requirement is to produce column value based on the parameter (ex: for year 2023, the based value is 100). and the subsequent year is based on the based year +/- the growth.

 

Please find the attached file for the sample workbook

 

Thank You

5 Antworten
  1. Hari Ankem (8x Tableau Ambassador)
    22. Apr. 2018, 05:46

    You can use this formula to derive the values as required:

     

    [Based Year Value]*((1+SIGN([DiffYear])*[Yearly Growth])^ABS([DiffYear]))

     

    You can use this formula to derive the values as required: [Based Year Value]*((1+SIGN([DiffYear])*[Yearly Growth])^ABS([DiffYear])) A 10.5 workbook is attached. Hope this helps.

     

    A 10.5 workbook is attached. Hope this helps.

Antwort schreiben...
0/9000