Post

2 followers Follow
1
Avatar

Adding line breaks to formula column in a report

I have a business user trying to create a formula column in a report that has line breaks in it. Everything we have tried so far is not producing any new lines. We have tried changing the field type, tried different commands for new line but nothing has produced any results so far. The formula in the column right now is as below. I have highlighted in bold the area of concern. 

IF($C_ProjectStatusEMEA="5A - Construction (Post Approval) <$5mill" || $C_ProjectStatusEMEA="5B - Construction (Post Approval) >$5mill" || $C_ProjectStatusEMEA="6 - Completed" || $C_ProjectStatusEMEA="7 - Archived",

" APPROVED Figures: " + " \n EREIC: " + " " + ToDate($C_EREICApprovalEMEA) + " \n RFS: " + " " + ToDate($C_ApprovedRFSEMEA) + "\n  Avail Power: " + " " + $C_ApprovedAvailablePowerkWEMEA + "\n Cabs: " + " " + $C_ApprovedCabinetsEMEA + "\n Budget: " + " " + "$" + Truncate($C_ApprovedBudgetUSDEMEA),

" FORECAST Figures: " +

" EREIC: " + " " + ToDate($C_SuggestedFinalEREICEMEA) +

" RFS: " + " " + ToDate($C_ForecastRFSEMEA) +

" Avail Power: " + " " + $C_ForecastAvailablepowerkWEMEA +

" Cabs:" + " " + $C_ForecastCabinetsEMEA +

" Budget: " + " " + "$" + Truncate($C_CurrentEFCUSDEMEA))             

Tyler Montileone

Please sign in to leave a comment.

1 comment