apply map

[raadwiptec]

For ex:   I do a apply map from the invoice rate table

Mapping Load,

Year & Month

Invoice Rate

xxxxx

so based on my year and month for ex if it 2017 01 then invoice rate would be used and multipllied with the end column

for 2016 12 the specific rate would be multiplied.

Now i want to apply 2017 rates all the previous years.

any sugg

[MayilVahanan]

hi

So 201701 invoice rate need to apply for 201601, similarly for 201702 invoice rate need to apply for 201602. in that case, try like below

MapInvoiceRate:

Mapping load Month, InvoiceRate from sourcetable where Year = 2017;

In applymap state,

Applymap('MapInvoiceRate', Month)

[avinashelite]

could you please explain with an example that would be better to understand