How to set current week as unelapsed
Hi Experts,
In MFP-CS v18.x, I want to set a boolean measure as 'unelapsed' only for current week and want to populate 'late on-order' measure in the current week from past elapsed weeks. I am using below rules and executing through daily batch, but the below Rule 1 (tried both options) is failing and MPWPFUnElapB isn't updated. All the below LHS & RHS measures base intx are 'week_scls_chan'
Rule 1: MPWPFUnElapB = if(current == today, TRUE, FALSE)
OR
Rule 1: MPWPFUnElapB = current == elapsed + 1
Rule 2: MPWPOOLR = if(MPWPFUnElapB, tssum(MPWPOOR, first, elapsed), 0)
Any quick help will be highly appreciated.
Thanks