I am looking at a report that was created before my time with the company and I am having trouble deciphering part of the load script and a formula that ties to the fields in question.
The load statement in question is below. VBRP.FKDAT is Invoice Date FYI.
Year(VBRP.FKDAT) as KAL_FKDAT.Jahr_FKDAT,
The formula i am trying to decipher after that is:
if today is Jan 1-5, then return sum of ({Invoice Date Year = two years ago} invoice amount / absolute value (Exchange Rate)), else return sum of ({Invoice Date Year = last year} invoice amount / absolute value (Exchange Rate))