Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I had a date? example 2017 transactions only
sum (If (Transactions.Pending = 0 or IsNull(Transactions.Pending), if ([Transactions.Cost Or Revenue] = 'Act Cost' and (Match ([Transactions.Txn Type], 'Inventory Adjustment')
or (Match([Transactions.Classified Account Type], 'Income'))), -[Transactions.Amount With Sign],
if([Transactions.Cost Or Revenue] = 'Act Cost' and Match([Transactions.Classified Account Type], 'Liability'),-[Transactions.Amount With Sign],
if ([Transactions.Cost Or Revenue] = 'Act Cost', [Transactions.Amount With Sign], 0)))))
Perhaps this?
sum (If ((Transactions.Pending = 0 or IsNull(Transactions.Pending)) and Year = 2017, if ([Transactions.Cost Or Revenue] = 'Act Cost' and (Match ([Transactions.Txn Type], 'Inventory Adjustment')
or (Match([Transactions.Classified Account Type], 'Income'))) and Year = 2017, -[Transactions.Amount With Sign],
if(([Transactions.Cost Or Revenue] = 'Act Cost' and Match([Transactions.Classified Account Type], 'Liability')) and Year = 2017,-[Transactions.Amount With Sign],
if ([Transactions.Cost Or Revenue] = 'Act Cost' and Year = 2017, [Transactions.Amount With Sign], 0)))))
Doesn't work. still trying to create