Prefix text

[Nikhil2725]

Hi Team,

I have table below:

Sl num	Is_correct_answer	Question_text	Answer_text
1	0	what is the national sport of India	Cricket
2	0	what is the national sport of England	Hockey
3	1	what is the national sport of Brazil	Football
4	1	what is the national sport of South Africa	Rugby
5	1	what is the national sport of China	Table Tennis

If the Is_correct_answer=0 then, I should append Incorrect before displaying the Answer_text

Is_correct_answer=1 then, I should append Correct before displaying the Answer_text

However, I want to display as below:

Sl Num	Question_text	Updated Answer_text
1	what is the national sport of India	Incorrect: Cricket
2	what is the national sport of England	Incorrect: Hockey
3	what is the national sport of Brazil	Correct:Football
4	what is the national sport of South Africa	Correct:Rugby
5	what is the national sport of China	Correct:Table Tennis

 Kindly help me in displaying as above.

[Nikhil2725]

Hi Sunny,

I have attached the image where I am getting wrong Prefix value.

For the A4 that should be incorrect as per the DB, however if I apply the same formula its not working.

[sunny_talwar]

Can you add E_is_correct_answer as one of the dimension to show that the value is actually 0?

[Forrounce]

thank you, you helped me a lot!