TM1 Forum

Thanks,

I Will try what you said and get back to you with my results

Ive changed the code a little please see below ['Register']=n:IF(ATTRN('CRL BAR Period',!CRL BAR Period,'Presentnum')>0,DB('Test1',!CRL Branch,!CRL BAR Period,!CRL BPR Scenario,'Register Available'),DB('Test1',!CRL Branch,ELCOMP('CRL BAR Period',!CRL BAR Period,ELCOMPN('CRL BAR Period',!CRL BAR Peri...

Hi I wonder if anyone can help me Rule Editor ['Register']=N:IF(ATTRS('CRL BAR Period',!CRL BAR Period,'Present')@='TODAY',DB('Test1',!Branch,!CRL BAR Period,!CRL BPR Scenario,'Register Available'),STET); ['Register available']=C:If(ELLEV(' BAR PERIOD',!BAR PERIOD)<>0 ,DB('Test1',!CRL Branch,!BAR Pe...