CAGR Formula

[sunitha_chellaiah]

Hello All,

Help me out to write below mentioned formula in qlik sense measure box. I want to calculate 6 years CAGR.

[(sale of 2019/sale of 2014)^(1/5) – 1]*100

Thanks.