Due Date Calculation Formula based on Terms Date and Terms Name in OTBI Report

Summary

Looking for a formula to derive Due Date based on Terms Date and Terms Name in OTBI Repoert

Content

Hi All,

I have a requirement to derive Invoice Due Date based on Terms date and terms name.  I am using following subject area which has Terms Date and Terms Name

OTBI Subject Area :-  [Payable Invoices - Transaction Real Time]

I want to calculate Invoice Due date based on Terms Date and Terms name on the Payable invoices. Please suggest the formula or custom SQL to achieve this.

Appreciate your help !!!

Example:-

Terms Date  =  05/07/2019 (MM/DD/YYYY)

Terms Name = Net30  (Or can be Net15, Net60, Net90, Immediate etc,.)