Im working on an xirr expression and some how number are showing blank when I have a value of 10 or 1 for Type="EMV". I tried on excel and it works fine. However when I change the value to 20 for Type="EMV, XIRR does show with -99.767%
What I try to accomplish here is when I use this xirr function in Excel I can compute an IRR % when "EMV" = 0, so I thought it might be the "0" cause not showing any value within Qlikview. I guess, there are unknown reasons why it's not showing on Qlikview.