QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for
Did you mean:
Creator

Help with number in text

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

4 Replies
Master II

Round(

MVP

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)

Creator
Author

totally worked! thanks

Master

Hi Silvia,