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.

     

Payeras_BI's avatar
Payeras_BI
Solution Sage
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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Yes it worked! Does this mean bigger and lesser than statements always result in true when having null as date value?