Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to filter out all records that are not 75% or greater.
Proj75overFilter:
LOAD
FISCAL_YEAR AS jFisYear
,ACCOUNTING_PERIOD AS jActPer
FROM [lib://QVD Files/PeopleSoft/Proj75over.qvd]
(qvd)
where
FISCAL_YEAR <= 2020
and ACCOUNTING_PERIOD <=12
and (Sum(SPEND)*100/Sum(BUD)>=75.00
;
Suggestions?
Since no one esle is answering, I would typically do this in a two step process. First I would load the table as a temp table, and do the needed calcuation. Then, I would do a resident load of that table with the appropriate WHERE clause. It is a bit clunky, but it will work and is pretty simple. Just remember to drop your temp table after the resident load.
There is likely a way to do this with a GroupBy function, but I have not explored that at all.
Good luck,
Nate