Hello:
How may I fix this error?
Thanks
IIF([Date]> [Yesterday],Null(),1+((DateTimeDiff([Yesterday],[Date],"days")* 5 -([StartWeekdays] -[EndWeekDays]) * 2)/7) + (IIF([EndWeekDays] ==6,-1,0)+IIF([StartWeekdays]==0,-1, 0)))
@Kinetic_analytics
It seems that the column [EndWeeksDays] is a string type, which should be numeric type.
Can you kindly provide a data sample set?
Thank you.