Forum Discussion
Solved
if statement
Model Name OD DATE OD1 OD2 DATE OD2 OD3 DATE OD3 A 1/3/2021 YES 4/4/2021 YES - B 1/1/2021 YES 1/6/2022 NO 1/3/2021 YES C 1/3/2021 YES 4/4/2021 YES 2/10/2022 YES...
SelflearningBi So maybe a Complex Selector like:
Selector Measure = IF( [OD DATE] <> BLANK && [OD1] = "YES" && [OD2 DATE] <> BLANK() && [OD2] = "YES" && [OD3 DATE] <> BLANK() && {OD3] = "YES", 1, 0 )
SelflearningBi So maybe a Complex Selector like:
Selector Measure =
IF(
[OD DATE] <> BLANK && [OD1] = "YES" && [OD2 DATE] <> BLANK() && [OD2] = "YES" && [OD3 DATE] <> BLANK() && {OD3] = "YES",
1,
0
)