Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculated column based on lookup table returns empty

I'm trying to calculate for every contract in a dataset with contracts whether or not a specific budget applies or not. This budget I need to detract from my overall figure, so I need to have it on a...
calculated column
condition
multiple conditions
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thank you for reproducing my problem in any case! This helped enormously since I knew it was not a problem of calculation, rather a data-problem on my end. I found the problem in the end, where it was one of the columns not exactly matching the comparable column in the other table. So my code did not find any matches and therefore returned empty. Thank you!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you for reproducing my problem in any case! This helped enormously since I knew it was not a problem of calculation, rather a data-problem on my end. I found the problem in the end, where it was one of the columns not exactly matching the comparable column in the other table. So my code did not find any matches and therefore returned empty. Thank you!