Dual Function

[#1]

Dual (

Country & '-' &

Num(Sum(sales), '#,##0') &

Repeat(chr(13)&chr(10), rank(sum(sales)) -6),

sum(sales)

)

Plzz explain me this expression m not getting what is happening within this expression.

Thanks & Regards,

Qliker

[#2]

the function dual recive 2 values. 1 number (used on all calculations) 1 text(used only for show information for user).

in this case if you use a pie chart. show de sum of country, the reapt dont make number stway thogeder...

[Anil_Babu_Samineni]

=Dual (

Country & '-' &

Num(Sum(sales), '#,##0') &

Repeat(chr(13)&chr(10), rank(sum(sales)) -6),

sum(sales)

)

As i understand, This requirement is for Calculate the Rank - 6 for Sales(If current Rank is 10, Requirement need 4th Rank)

Repeat function is repeated values. Here, Chr(13) is Spaces and Chr(10) is Next line

Might be Clear