Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Table.ReplaceValue custom step not working

I have the following custom replace value step. However it doesn't work.  Original value of [Woendag]= 8 Value it should replace to = 0 Value it shows instead = 8 Expression:             ...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    3 years ago

    Hi Anonymous ,

    The issue comes from having null values in [StartDateZZZ] and [EndDateZZZ] as this 

    [Date] >= [StartDateZZZ] and [Date] <= [EndDateZZZ]

    is evaluated before 

    PercentageDisablement] > 0

    Try substituting null dates by with a dummy date like 01-01-1900 and it should work like expected.