topic Re: Help with number in text in QlikView

Help with number in text

silvia_assuncao — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 30 Jun 2017 15:28:11 GMT

Round(

Your Number Expression ,.0001)

sunny_talwar — Fri, 30 Jun 2017 15:35:55 GMT

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 — Fri, 30 Jun 2017 15:58:05 GMT

totally worked! thanks

effinty2112 — Fri, 30 Jun 2017 21:21:17 GMT

Hi Silvia,

Please remember to mark this question as Answered by Sunny.

Kind regards

Andrew