Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Round(
Your Number Expression ,.0001)
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)
totally worked! thanks
Hi Silvia,
Please remember to mark this question as Answered by Sunny.
Kind regards
Andrew