Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have written the following expression. My 'Date' should be selected on the basis of a set of conditions :
=sum({<Shift={'Shift A'},Date={
if($(CurrentTime) ={">=$(From1)<=$(To1)"}, $(MaxDateMinus1),
if($(CurrentTime) ={">=$(From2)<=$(To2)"}, $(MaxDate),
if($(CurrentTime) ={">=$(From3)<=$(To3)"} ,$(MaxDate),
if($(CurrentTime) ={">=$(From4)<=$(To4)"},$(MaxDateMinus1),$(MaxDate)))))
}>} Alarm)
But I'm getting the following error:
Could anyone please point out what I'm doing wrong ?
I think that the {} brackets should not be there for {">=$(From1)<=$(To1)"} because this is not a definition within the set analysis, but a logical if condition, try plain brackets ()
I think your trying to evaluate if statement in Date and it doesn't have " " around it try like
Date={"
if($(CurrentTime) ={">=$(From1)<=$(To1)"}"}