Hi everyone, how do I format the result my saved s...
# suiteanalyticsn
NS.TX
07/01/2019, 8:03 PMHi everyone, how do I format the result my saved search formula (numeric): {amount}-{billingtransaction.amount}
say, text color red and bold - I've made a couple attempts on my own, but they were not successful!
g
Gregory Jones
07/01/2019, 8:28 PMHow are you trying to do this?
Gregory Jones
07/01/2019, 8:28 PMvia HTML in the formula?
Gregory Jones
07/01/2019, 8:43 PMIf you're trying via HTML, it won't work in a Formula (numeric) - has to be Formula (text)
Gregory Jones
07/01/2019, 8:51 PMWithout knowing more about your search, you could try this:
'<span style="color:red;font-weight:bold">'|| ({amount}-{billingtransaction.amount}) ||'</span>'k
KevinJ of Kansas
07/02/2019, 1:33 AMTry using nvl to return 0 when null too
👍🏻 1
KevinJ of Kansas
07/02/2019, 1:34 AMAlso try looking into highlighting rules
n
NS.TX
07/03/2019, 6:13 PM@Gregory Jones @KevinJ of Kansas Thank you for the suggestions, I'll lyk if I'm successful! I forgot I tossed this out there, so I apologize for the delayed reply.
g
Gregory Jones
07/03/2019, 6:14 PMGood luck, hope you're able to get what you need (or at the very least, close enough to it).