Hi All,
Need to capture Special deal and standard deal separately against charge number available in week 31 report sheet by using following steps:
Need your help with the attached, I need rates for charge number and charge type for 2 specifics as I need to show variance in rates if calculated on PCD (highlighted in green) basis and Discharge date (highlighted in green)
There needs to a unique ID made combining Charge Number, Charge type and Commodity (highlighted in yellow)
If the date falls in between the active date range then we need to copy the entire row against that charge number or unique id.
Sharing sample data attached as actual data is huge.
Regards,
Satyawan
Need to capture Special deal and standard deal separately against charge number available in week 31 report sheet by using following steps:
Need your help with the attached, I need rates for charge number and charge type for 2 specifics as I need to show variance in rates if calculated on PCD (highlighted in green) basis and Discharge date (highlighted in green)
There needs to a unique ID made combining Charge Number, Charge type and Commodity (highlighted in yellow)
If the date falls in between the active date range then we need to copy the entire row against that charge number or unique id.
Sharing sample data attached as actual data is huge.
Regards,
Satyawan