How to calculate EOD balance for the last day of Previous month based on accounting date in OTBI — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to calculate EOD balance for the last day of Previous month based on accounting date in OTBI

in Reporting and Analytics for ERP 2 comments

I'm trying to calculate the End of the day balance for the last day of previous month based on accounting date which I'm passing as a parameter in the OTBI Analysis.
Subject Area: General Ledger - Average Daily Balances Real Time

I'm using the following formula to calculate the value, but it is not giving any values in the result.

FILTER("Daily Balances"."End of Day Balance" USING (("Time"."Fiscal Date" IN (TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH("Time"."Fiscal Date") * -(1) + 1, "Time"."Fiscal Date"))))))

Questions:

  1. Is there a standard way in oracle fusion OTBI to calculate the End of the day balance (EOD) for the last day of previous month (LME) based on accounting date ?
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!