Formatting in text box not working

[helen_pip]

Dear all

I am calculating an expression in a text box, which unfortunately does not format to set format I have written

The calculation is:

=100-(Num(Count({$<FactDateNum ={">=$(=v_Start_Date_OP)<=$(=v_End_Date_OP)"}, OP_Atd_Ethnic_Code={'Z', '99'}>} If(OP_Atd_Outcome_Type= 'ACTION',OP_Atd_ID)) /

Count({$<FactDateNum ={">=$(=v_Start_Date_OP)<=$(=v_End_Date_OP)"}>} If(OP_Atd_Outcome_Type= 'ACTION',OP_Atd_ID))*100,'0.0'))

The issue is surrounding the first part of the equation as putting 100- at the beginning, seems to ignore the formatting and I get 91.52689164 instead of 91.52

Does anyone have any ideas as to why the 100 is causing me problems

Kind Regards

Helen

[boorgura · Accepted solution]

=Num(100-(Count({$<FactDateNum ={">=$(=v_Start_Date_OP)<=$(=v_End_Date_OP)"}, OP_Atd_Ethnic_Code={'Z', '99'}>} If(OP_Atd_Outcome_Type= 'ACTION',OP_Atd_ID)) /

Count({$<FactDateNum ={">=$(=v_Start_Date_OP)<=$(=v_End_Date_OP)"}>} If(OP_Atd_Outcome_Type= 'ACTION',OP_Atd_ID))*100),'0.0')

[helen_pip]

Hello Rakesh

Thank you!  This now works!   Why I didn't think of that, I will never know

[boorgura]

Happens all the time! Helps to have an extra pair of eyes to take a look!