Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
='Sales : ' & Num(Sum(Sales), '#,##0')
Hi,
Text (Sales : ) + Sum(sales) in format '#,##0'
Hope this helps.
Andrei
Hi,
Num() is formated your output of Sum(Sales) in Integer format
and Sales is text appended using & special character.
& work as concat two fields.
Regards
Hi,
Text (Sales : ) + Sum(sales) in format '#,##0'
Hope this helps.
Andrei
Hi
you having sales data
first it is performing sum of data then whatever data comes as result on that resultant data again you are performing num with specific format which you are assigning in second parameter .