I have a column with date values and would like to create another column for an YTD (Year to date) analysis.
How can I use somehow a node with an “IF Condition” like this: If (Date<=“May”) than “YTD” else “budget”.
Any other help would be good!
you could have a look at the Column Expressions node. It can be used to execute JavaScript snippets on each row of an input table. You could just write your IF statement and output a new column with the desired values.