Script/Formula Decipher

JustinRamsey — Fri, 02 Aug 2019 19:31:07 GMT

Good Afternoon,

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( num(month(today())) = 1 and num(day(today())) <= 5,
sum( {$< KAL_FKDAT.Jahr_FKDAT = {"$(=year(today())-2)"} >} VBRP.NETWR_EFF / fabs(VBRP.REPORT_USA_KURRF) ),
sum( {$< KAL_FKDAT.Jahr_FKDAT = {"$(=year(today())-1)"} >} VBRP.NETWR_EFF / fabs(VBRP.REPORT_USA_KURRF) )
)

Field VBRP.REPORT_USA_KURRF is Exchange Rate and field VBRP.NETWR_EFF is the invoice amount.

Can anybody explain to me exactly what that function is doing?

Re: Script/Formula Decipher

lockematthewp — Fri, 02 Aug 2019 19:55:54 GMT

Hope this helps.

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))

topic Script/Formula Decipher in QlikView

Script/Formula Decipher

Re: Script/Formula Decipher