<@UA25FV141> Hey Laurie, that's possible, just use...
# generalc
Camden (WMP)
06/03/2019, 9:00 PM@Laurie J. Hey Laurie, that's possible, just use a CASE WHEN xyz THEN 'display this value' ELSE '' END. the '' between ELSE and END will then show null value if the CASE WHEN is not met
l
Laurie J.
06/04/2019, 2:30 PM@Camden (WMP) 🙂
Laurie J.
06/04/2019, 2:42 PM@Camden (WMP) but the issue is the case when part of the statement, do i just use (for example) the trans type?
c
Camden (WMP)
06/04/2019, 2:43 PMYep, so it would look like CASE WHEN transaction.type = 'Invoice' THEN 'This is an invoice' ELSE '' END
l
Laurie J.
06/04/2019, 2:44 PMso case when {type}= 'Bill Payment' THEN 'display createapprovedpurchase" ELSE " END
Laurie J.
06/04/2019, 2:44 PMok i got it
Laurie J.
06/04/2019, 2:44 PMi should have just sent you an email!
c
Camden (WMP)
06/04/2019, 2:47 PMHahaha I suppose that's why you have my email and cell 😊
3 Views