Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sorry I missed >}
='Ocp: ' & (Num(Count({<DISPO = {'N'}>} DISPO)/Count(P0703_NOMBRE) ,'#,##0%'))
Try this:
='Ocp: ' & (Num(Count({<DISPO = {'N'} DISPO)/Count(P0703_NOMBRE) ,'#,##0%'))
H Tks synny but i have the next error:
error int ext modifier expression
Sorry I missed >}
='Ocp: ' & (Num(Count({<DISPO = {'N'}>} DISPO)/Count(P0703_NOMBRE) ,'#,##0%'))
I think , did you forget the "num" func at the beggining of the sentence? num(formula,'#,##0%')
Ty
Excelent Tks. it works.
Great, please close the thread by marking the correct answer