Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=pick(WildMatch(Vcurrency,1,2,3),num(sum(Sales_INR)/1000,'₹#,###.0' &' '& 'K'),
num(sum(Sales_EUR)/1000,'€#,###.0' &' '& 'K'),
num(sum(Sales)/1000,'$#,###.0' &' '& 'K'))
Hi @Vijaydurga ,
You have converted the number in the string in the formula by adding 'K' and ₹ while formating the number