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
MFelix's avatar
MFelix
Super User
9 years ago
Don't know if the question.is relsted with this but try to change the dot-comma by comma cannot repest your error on the computer right now.

MFelix
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