Error on text in chart

[#1]

Hi, im trying to use ='Ocp: ' & (count(if( DISPO = 'N', DISPO))/Count (P0703_NOMBRE) ,'#,##0%') to have the result in %, but i have error in the expresion

any suggestion

Tks

[sunny_talwar]

Try this:

='Ocp: ' & (Num(Count({<DISPO = {'N'} DISPO)/Count(P0703_NOMBRE) ,'#,##0%'))

[#3]

H Tks synny but i have the next error:

error int ext modifier expression

[sunny_talwar · Accepted solution]

Sorry I missed >}

='Ocp: ' & (Num(Count({<DISPO = {'N'}>} DISPO)/Count(P0703_NOMBRE) ,'#,##0%'))

[#5]

I think , did you forget the "num" func at the beggining of the sentence? num(formula,'#,##0%')

Ty

[#6]

Excelent Tks. it works.

[sunny_talwar]

Great, please close the thread by marking the correct answer

Qlik Community Tip: Marking Replies as Correct or Helpful