Forum Discussion

AshPower's avatar
AshPower
Frequent Visitor
9 years ago

Help with display chart

My table have following column Datetime/Device/TestName/Pass/Fail Note: If test passed at specific Datetime Pass value is 1 and Fail is 0.   I am looking to diaply the pass and fail value for the ...
Need Help
AshPower's avatar
AshPower
Frequent Visitor
9 years ago

I am using this

ValFail = IF(
VALUES(ResultLDR[Result])= "Fail",
UNICHAR(9635),
UNICHAR(9634)
                 )
& REPT(" ", 5)

MFelix's avatar
MFelix
Super User
9 years ago

Try to use this one:

 

PASS/FAIL = 
IF(
    FIRSTNONBLANK(Table1[Pass_Fail],"Fail")="Fail", 
        UNICHAR(9634), 
        UNICHAR(9635)
) 
& REPT(" ", 5)

Regards,

MFelix