Forum Discussion
Calculate the Difference between the Values in indirectly related columns
I am trtying to calculate the difference between the "Amounts" of RoomRevenue for the two tables attached below, for the same "Dates", "Data Type" (Budget =1 and Forecast =2 in the second table), "SPOListID"
Anonymous
You may use IF Function or SWITCH Function to add a calculated column, then refer to this link.
1 Reply
v-chuncz-msftCommunity Support
Anonymous
You may use IF Function or SWITCH Function to add a calculated column, then refer to this link.