Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone tell me what they mean by "Chr(10)" in this expression
>>>>>>>>>>>>>>>>>
='Max Value: ' & Max(Aggr(Count(DISTINCT [From - To State Code]),
[Carrier Name])) & Chr(10) &
'Min Value: ' & Min(Aggr(Count(DISTINCT [From - To State Code]),
[Carrier Name])) & Chr(10) &
'Avg Value: ' & Avg(Aggr(Count(DISTINCT [From -
To State Code]), [Carrier Name]))
>>>>>>>>>>>>>>>>>
Thank you,
Chr(10) is a line feed character. It forces the text after it to continue on the next line.
It will output a character with ASCII code 10 - Line Feed: