Need expression

[#1]

how can i calculate payout for a customer.my payout is depend upon delay days

• Data provided 1-10 calendar days late: deduction in Fees of ten percent (10 %)
• Data provided 11-20 calendar days late: deduction in Fees of twenty percent (20 %)
• Data provided 21-30 calendar days late: deduction in Fees of thirty percent (30 %)
• Data provided 31-90 calendar days late: deduction in Fees of fifty percent (50%)
• Data provided more than 90 calendar days late: no Fees due

how can i get these any suggestion would be helpful

[datanibbler]

Hi Kannuri,

easy:

- You can easily calculate the payout with a discount by just multiplying it by 0.9 (10% deduction) etc.

- You can calculate the days_of_delay by subtracting the cutoff_date from the provided_date (that will give you a nr. of days)

=> Then you just have to construct an IF_construction. With your five possibilities, a PICK(MATCH) construct might be more performant, but for that you'd have to take the extra step of making categories. Try with IF for starters.

HTH

Best regards,

DataNibbler