GParreiras
2 days agoNew Contributor III
GetDataCell Error in CV
Hi All,
Any idea why the formula below won't work in CV?
GetDataCell(T#|!Par_Time!| - T#|!Par_Time!|.Prior1)
The first column contains the formula, and the second one contains this: T#|!Par_Time!|.Prior1.
Regards,
Hi,
The formula doesn't work because, as far as I understand, GetDataCell() doesn’t support evaluating expressions or ranges within the time member. It expects a single, valid member reference. If we need to compare periods, we typically call GetDataCell() separately for each time member and perform the calculation.
Happy to be corrected if there’s another supported approach.
Thanks,