Skip to Content
avatar image
Former Member

how to calculate number of days in a month based on key date variable?

Hi Folks,

We are developing a query DPO (Days payable outstanding report) in that to calculate

DPO the formula is (Accounts Payable+Provisions/Cost of Sales) * No of Days.

so, here based on key date which we enter we need to get no of days dynamically & calculate no of days.

Appreciate your valuable inputs for solving this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 08, 2017 at 08:22 AM

    search for formula variable

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Navalan,

      In this case, I'd rather create 1 input variable(with month), and one customer exit variable(with number of days) which is calculated in i_step = 3, after all the inputs have been done, and use customer exit variable in the formula.

      Kind regards,

      Andrey