Forum Discussion

Mmartinetti's avatar
Mmartinetti
New Member
2 years ago
Solved

last purchase cost

Hi community, I created a matrix in which I have in the rows the article code, in the columns the months and in the values the last purchase cost, like this: I would like to create a formula ...
Need Help
  • MNedix's avatar
    MNedix
    2 years ago

    Hi,

    I assume this table is coming from your source data so are you sure you want to back-fill the values you have in your data? I am sure there is a much better solution but what you could do for now, is create another 12 calculated columns and use the logic - if [Initial Column] = empty THEN [Previous Column] value

    For example: New Mag = IF(ISBLANK[Mag], [Apr], [Mag])

    However, this doesn't address the blank value for [Gen] so I would do it only until I find a better solution.

MNedix's avatar
MNedix
Icon for Solution Sage rankSolution Sage
2 years ago

Hi,

I assume this table is coming from your source data so are you sure you want to back-fill the values you have in your data? I am sure there is a much better solution but what you could do for now, is create another 12 calculated columns and use the logic - if [Initial Column] = empty THEN [Previous Column] value

For example: New Mag = IF(ISBLANK[Mag], [Apr], [Mag])

However, this doesn't address the blank value for [Gen] so I would do it only until I find a better solution.

  • MNedix's avatar
    MNedix
    Icon for Solution Sage rankSolution Sage
    2 years ago

    PS: if this solved your problem then please mark it as the solution