Open adumith opened 1 year ago
I have a formula that generates whose results I want to display in several lines, I am using UNICHARD (10) and (13) but none of them seem to work.
"Open: " & IF(xOpen > 0, xOpen, 0) & UNICHAR(13) & UNICHAR(10) & "Solved: " & IF(xSolved > 0, xSolved, 0) & UNICHAR(13) & UNICHAR(10) & "On-hold: " & IF(xOnhold > 0, xOnhold, 0) & UNICHAR(13) & UNICHAR(10) & "Scaled: " & IF(xScaled > 0, xScaled, 0) & UNICHAR(13) & UNICHAR(10) & "Pending: " & IF(xPending > 0, xPending, 0) & UNICHAR(13) & UNICHAR(10) & "First reply time brackets: " & FRTBMR & " | " & IF(FRTBMC>0,FRTBMC,0) & UNICHAR(13) & UNICHAR(10) & "Full resolution time brackets: " & FRTBUMR & " | " & IF(FRTBUMC>0,FRTBUMC,0) & UNICHAR(13) & UNICHAR(10) & "First resolution time brackets: " & FRESTBMR & " | " & IF(FRESTBMC>0,FRESTBMC,0)
I'm not sure if it's a bug, maybe it's using another code. Could you help with this?
I have a formula that generates whose results I want to display in several lines, I am using UNICHARD (10) and (13) but none of them seem to work.
"Open: " & IF(xOpen > 0, xOpen, 0) & UNICHAR(13) & UNICHAR(10) & "Solved: " & IF(xSolved > 0, xSolved, 0) & UNICHAR(13) & UNICHAR(10) & "On-hold: " & IF(xOnhold > 0, xOnhold, 0) & UNICHAR(13) & UNICHAR(10) & "Scaled: " & IF(xScaled > 0, xScaled, 0) & UNICHAR(13) & UNICHAR(10) & "Pending: " & IF(xPending > 0, xPending, 0) & UNICHAR(13) & UNICHAR(10) & "First reply time brackets: " & FRTBMR & " | " & IF(FRTBMC>0,FRTBMC,0) & UNICHAR(13) & UNICHAR(10) & "Full resolution time brackets: " & FRTBUMR & " | " & IF(FRTBUMC>0,FRTBUMC,0) & UNICHAR(13) & UNICHAR(10) & "First resolution time brackets: " & FRESTBMR & " | " & IF(FRESTBMC>0,FRESTBMC,0)
I'm not sure if it's a bug, maybe it's using another code. Could you help with this?