Forum Discussion

suresh_klarna's avatar
suresh_klarna
New Contributor II
16 hours ago

XFGetCell() + XFGetCell() gives incorrect result

statement 1: gives zero which is correct

=VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "F99", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))

statement 2 : gives value which is correct

=VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "FNONE", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))

statement 3: gives incorrect value

=VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "F99", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))+VALUE(XFGetCell(TRUE, "CONSO", B19, "", "Local", "ACTUAL", "2025M2", "YTD", D19, "FNONE", "BeforeAdj", "Top", "U1TOP", "U2TOP", "U3TOP", "U4NONE", "U5TOP", "U6NONE", "U7NONE", "U8NONE"))

This works correctly in 8.4, but not after upgrading to 9.1

No RepliesBe the first to reply