Modify formula to exclude value

building reports webintelligence
1

Hi,

I have the following formula below. I want to simply modify it to include one other object that says:…“And ([Object Here] Not equal to “C”” in an attempt to filter out another data point if the value is “C”. If this were Excel I could figure it out in two seconds, but I tried various Not functions but I’m just not getting it to work.

=Sum ([Delinquent Loan Summary].[Note Bank Share Ledger Balance] Where ([Delinquent Loan Summary].[Note Type Code] InList ("100";"101";"102";"103";"104";"105";"106";"107") And ([Delinquent Loan Summary].[Note Number of Days Past Due] Between (30;59))))
2

Either one of these should work…

And ([Object Here] <> "C")

or

And (Not([Object Here] InList ("C")))

1 Like