Forum Discussion
XIRR Calculation Error
Hi, I am trying to calculate XIRR for a given set of cashflows, which comply with all rules of XIRR function, but I am still getting an error. Please see my data below, Can anyone please help...
what do you mean by "[@Amt]" in your example? I'm trying to recreate this since I am having the same issue but I don't know what this is referencing. Thank you
AlexisOlson
Super User
Super User[@Amt] is the name of the column I defined as SUM ( Table[Amount] ) in the Summary variable.