Forum Stats

  • 3,759,041 Users
  • 2,251,494 Discussions
  • 7,870,477 Comments

Discussions

FRS nested ifthen for CAGR calculation

Hi,

I'm trying to build a CAGR calculation in my FRS report. While I can get the actual CAGR calculation of "(Column[N]/Column[B])^(1/4)- 1" to work, I cannot seem to get the ifthen to work. I'm trying "IfThen([B]=#missing,0,((Column[N]/Column[B])^(1/4)- 1))", and I get error messages. How can I nest the CAGR formula in an ifthen that references missing?

Thanks!