Calculating the number of nights for accommodation

[Jaewon]

We received a request from the client regarding this. Please let us know how to set up automatic calculations in the Expense Entry Form using the formulas based on the selected field values in the list for the Expense Type. If there are any additional settings or information needed, please let us know. Thank you.

[PoojaKumatkar]

Hi @Jaewon ,

I want to understand why you are using custom drop down list to select number of nights if system is calculating it by default.

What you want to achieve? I could see in formula that you have used V_A1 and 30. For what purpose it is used for and what you are maintaining in validation table under Amount 1 column?  I mean location/country wise amounts or something...

If you could clarify this then I might be able to help.

[KevinD · Accepted solution]

@Jaewon a couple of things I need to mention:

1. Number of nights is calculate automatically by the system based on the Hotel or Accommodation expense type. I'm not sure why your client would ask for this. Using a list and trying to do a calculation seems like way too much work for something that already exists.

2. I looked up your email address and I see you work for a Certified Implementation Partner. I need to inform you that we have been directed by our Partner Team that all certified partners should be submitting any help/support requests to the Partner Support Portal. We have dedicated resources for providing support to our partners, so your one and only place for getting help should be through the Partner Support Portal. If you have never accessed the Support Portal, I would recommend speaking with someone at your company who has and ask them for help with getting access to the portal.