Hi,I want to calculate amount for selected quarter and previous quarter using presentation variable.I have created presentation variable with quarter name and given default quarter is Q2/2024.Now I want to calculate amount for Q2/2024 and Q1/2024. ...
How can I create a KPI with a formula that contains the following: SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column)i want the right formula that give me Total of average amount_granted group by approval date
I've created an aggregate dashboard with attached layout (linked to JDE). The business wants to see the individual transaction with qty and amounts as well as having a running total column against each of the respective records. This is to assist in ...
Hi,Could you please someone explain me how "First Version" function works?Formula:sum( firstVersion( EBS_GL.GL_BALANCES.BEGIN_BALANCE_DR_BEQ - EBS_GL.GL_BALANCES.BEGIN_BALANCE_CR_BEQ, EBS_GL.GL_BALANCES.CODE_COMBINATION_...
I was trying to create a very simple listing table of a few columns (Brokers name, Sales office, customer). It works however it is displaying duplicate rows of data. Is there a way to do a distinct on a listing table? Or is there a way to remove dupl...
.svg "Partner"){kind=icon}