Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=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')
=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')
Hello Rakesh
Thank you! This now works! Why I didn't think of that, I will never know
Happens all the time! Helps to have an extra pair of eyes to take a look!