Per Diem Expense by Day only

Hii

I ahve a requirement to generate Per Diem Allowance and I have done the configurations accordingly. The problem is I have activated the NUmber field also to get teh number of days based on Trip Start Date and End Date which is also happening correctly but I am unable to generate the Total Amount field correctly based on number of days.

Say per diem is 100

My trip is for 5 days, so the Receipt amount should be 500 ( 100 * 5 days). Currently, it is only defaulting to 100 instead of 500 and the multiplication is not happening. I have choosen No Day Scalling and based on Calender days.

Appreciate your help.

Thanks.