Forum Discussion

GParreiras's avatar
GParreiras
New Contributor III
24 days ago
Solved

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,

 

Infrastructure
Metadata
  • Rithik_Prem's avatar
    Rithik_Prem
    23 days ago

    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,

1 Reply

  • Rithik_Prem's avatar
    Rithik_Prem
    New Contributor III
    23 days ago

    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,