IBM Apptio

Hi,

I'm trying to copy the values of a row down a column until a new row value appears, then copy the new value down, and so on.

Here's an example of a table in TBM Studio, where Date and ID are two columns in the raw data received, and the Output column represents the desired result.

I know that in Google Sheets, I can use the following formula to achieve this:
=IF(A2<>"", A2, C1).

However, I'm having trouble finding a similar formula that works in TBM Studio. Has anyone else encountered a similar use case and found a solution?

Hi, Aaron,
You won't be able to reference other rows like a spread sheet.
You should be able to use a formula like: =if(Date="", Output, Date)