Tengo una fórmula para asignar valor a una columna, pero en algunas ocasiones me devuelve valor en blanco, la fórmula es la siguiente:
ANY(SELECT(Detalles_Turnos[INSPECTOR],
AND(
[TURNO].[FECHA]=IF(
AND(
TIMENOW()>TIME("00:00:00 AM"),
TIMENOW()<TIME("08:00:00 AM")
)
; TODAY()-1; TODAY()
),
[TURNO].[NUMERO]=[_THISROW].[TURNO],
[CELULAR].[EMAIL]=[_THISROW].[_USERMAIL] )))
Quiero asignar otro valor en caso de que la consulta anterior retorne blanco, muchas gracias por sus sugerencias!
Solved! Go to Solution.
Hey man;
put your statement in a Virtual Column (VC)
VC App formula =
ANY(SELECT(Detalles_Turnos[INSPECTOR],
AND(
[TURNO].[FECHA]=IF(
AND(
TIMENOW()>TIME("00:00:00 AM"),
TIMENOW()<TIME("08:00:00 AM")
)
; TODAY()-1; TODAY()
),
[TURNO].[NUMERO]=[_THISROW].[TURNO],
[CELULAR].[EMAIL]=[_THISROW].[_USERMAIL] )))
===================
Then you can use that VC content anywhere you want by using:
IF(ISBLANK([VC]), "Some Other Value", [VC])
Hey man;
put your statement in a Virtual Column (VC)
VC App formula =
ANY(SELECT(Detalles_Turnos[INSPECTOR],
AND(
[TURNO].[FECHA]=IF(
AND(
TIMENOW()>TIME("00:00:00 AM"),
TIMENOW()<TIME("08:00:00 AM")
)
; TODAY()-1; TODAY()
),
[TURNO].[NUMERO]=[_THISROW].[TURNO],
[CELULAR].[EMAIL]=[_THISROW].[_USERMAIL] )))
===================
Then you can use that VC content anywhere you want by using:
IF(ISBLANK([VC]), "Some Other Value", [VC])
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
16 |