I have data as below and neww to create a new column as below.
If the activity is OT need to add the year end and forecast if it is SU need the value from Forecast column.Thanks for help
Go to Solution.
Column = IF(Test[Activity]="SU",Test[Forecast],Test[Year End]+Test[Forecast])
View solution in original post
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!