I'm trying to pull in the corporate card amount (i...
# suiteanalyticss
S. T.
04/21/2023, 6:06 PMI'm trying to pull in the corporate card amount (it's in the summary section) on an expense report saved search. Everything I try comes up as zero. Anyone familiar with how to do this?
m
MGBC
04/21/2023, 6:06 PMYou have to use the line item of the expense report and only pull the ones where Non-reimbursable = T (or corporate card = T)
MGBC
04/21/2023, 6:07 PMThen make it a summary search to sum up all the amounts
MGBC
04/21/2023, 6:07 PMUsually i use a formula like this
Formula(Currency) CASE WHEN {coporatecard} = 'T' THEN {amount} END
s
S. T.
04/21/2023, 6:14 PMGotcha. Thank you!!