
Moving to the customizations section.
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))
Please sign in to leave a comment.
Moving to the customizations section.
I think you'll need to go through Professional Services to build this one out.