Compare line item month data to time dimension month data
In my module I have a line item that holds the value for Period when the Actuals should have the data. I have time dimension in columns by months
Is there a way I can write a formula and compare for example if the Period has April 20 then the formula would look at the column data for April 20 and check if Actuals line item has data or not?
Thanks in advance!!