I need help in writing this formula:
Test Result is varchar
p_test_result is varchar
Data look like:
Test Result=Fail
p_test_result=Pass
I want to compare both the columns
if {rpt_test1;1.Test Result}<>{rpt_test1;1.p_test_result} then
BOLD ({rpt_test1;1.Test Result})
else
{rpt_test1;1.Test Result}
I know above formula is wrong is any better way to write?.
Test Result is varchar
p_test_result is varchar
Data look like:
Test Result=Fail
p_test_result=Pass
I want to compare both the columns
if {rpt_test1;1.Test Result}<>{rpt_test1;1.p_test_result} then
BOLD ({rpt_test1;1.Test Result})
else
{rpt_test1;1.Test Result}
I know above formula is wrong is any better way to write?.