10 Replies Latest reply on Sep 10, 2018 3:47 PM by Hari Ankem

    Can't raise integer value to integer power

    Jeff English

      I'm trying to create a calculated field which takes a value and a date and discounts it to calculate net present costs. I've done this previously in Excel-linked workbooks using the equation [Value] * (1-i)^([Year] - 20##) where 20## is the discounting year (e.g. 2018). I'm trying to replicate this in a new workbook with an ODBC connection, but I'm getting errors like in the title. This occurs any time I try to include a field in an equation with exponents, such as 2^[Value] or [Year] ^ 3.2.