Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings!
I'm trying to create an expression that will give me sales (for the previous month PM) for a specific location (St.Cloud). This expression does not seem to be working for me??..??
=SUM({$<[Location Name]={'St.Cloud'}>}(=$(vTotalSales(PM))))
What am I missing?
What is the definition of
vTotalSales
-Rob
vTotalSales =
Sum({$<[%dateflag_$1]={1},
[Transaction Line Accounts Account Number]={404120,404110,404100,404118,404119},
[Transaction Type]={'Invoice','Cash Sale','Cash Refund','Credit Memo', 'Bill', 'Journal'}, $(vExcludeDateFields)>} [Transaction Line Gross Amount])