so when the leger is AP and Transaction_Type is INV and Organization Code is BES and Company_Code is MAA then is need the over all count of all these combinations
my question is I have multiple company codes and organization codes so how do I write a calculation field for that?
2 个回答
Hi @Preethika T
You can use IN, like this:
if [Ledger] = "AP" and
[Transaction Type] in ( "INV", "CRD") and
[Organization code] = "BES" and
[Compay Code] = "MAA"
then 1
else 0
end
----------------------------------------------------------------------------------------------------------------
Please upvote my helpful replies & choose Select as Best Answer if it really is the best :)
