Compare source value (period) with current month

Hi Community,

 

I was wondering if I can build a formula to compare a source date period (e.g. 201803 -> March 2018) with the current month to decide whether a related turnover value needs to be written into current-period column (current month) or previous-period (last month) column.

 

any help would be kindly appreciated.

Regards Oliver

(2) Answers

Login