Help with number in text

[silvia_assuncao]

Hi, could anyone help me get fix the number in the text?

below is my formula:

='2017 ('& ' $(=$(Max_Clos_2017))' & '+' & (12- '$(=$(Max_Clos_2017))')    & ')' &     '= R$ '&

(Sum(Aggr(

(Sum(DISTINCT(if((left(Month,2)<= ('$(=$(Max_Clos_2017))'))and ('$(=$(Max_Clos_2017))')=Currency_Closing_Period ,Act_Rate))))

+

(Sum(DISTINCT(if((left(Month,2)> ('$(=$(Max_Clos_2017))')) and ('$(=$(Max_Clos_2017))')=Currency_Closing_Period ,Est_Rate))))

,Month)))/12

the result is: 2017 ( 5+7)= R$ 3,215375. what change i should make so that the number would be 3,2153 only?

thanks

[m_woolf]

Round(

     Your Number Expression ,.0001)

[sunny_talwar]

May be this

='2017 ('& ' $(=$(Max_Clos_2017))' & '+' & (12- '$(=$(Max_Clos_2017))')    & ')' &     '= R$ '&

Floor((Sum(Aggr(

(Sum(DISTINCT(if((left(Month,2)<= ('$(=$(Max_Clos_2017))'))and ('$(=$(Max_Clos_2017))')=Currency_Closing_Period ,Act_Rate))))

+

(Sum(DISTINCT(if((left(Month,2)> ('$(=$(Max_Clos_2017))')) and ('$(=$(Max_Clos_2017))')=Currency_Closing_Period ,Est_Rate))))

,Month)))/12, 0.0001)

[silvia_assuncao]

totally worked! thanks

[effinty2112]

Hi Silvia,

Please remember to mark this question as Answered by Sunny.

Kind regards

Andrew