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

OTBI HOW TO TURN MEASURE COLUMN INTO YTD

Question
177
Views
0
Comments

Summary

OTBI HOW TO TURN MEASURE COLUMN INTO YTD

Content

Hi Xavier,

 

As per the below the YTD amount gets calculated from 1/Jan  to till date. However we have requirment to calculcated the YTD amount from 1/Apr to till date.

Below is the columns formula we are using to calculated the YTD amount. 

IFNULL(FILTER("Project Costing - Actual Costs Real Time"."- Expenditure Item and Cost Distribution Measures"."Cost" USING ("Fiscal Calendar"."Fiscal Date" >= TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM (@{AccountingDate}{date '2018-06-30'})) * -(1) + 1, (@{AccountingDate}{date '2018-06-30'})))), 0)

 

Could you please help to write the formula so that it add the column value from 1/Apr.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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