I need to calculate Monthly Returns using this algorithm:
Monthly Return (month i) = (Value (month i) - Value (month i - 1) ) / Value (month i - 1)
In other words, Monthly returnn of - i.e. - Febraury is equal to = (Value Feb - Value Jan) / Value Jan
An this for an undefinied number of rows...
Thanks in advance
A little uncertain but based on Quick Calc Percent Difference I think you could establish desired info
checked your calc also in excel and gives me the exact desired values -20% instead of -25%;)
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...