OTBI HOW TO TURN MEASURE COLUMN INTO YTD
Summary
OTBI HOW TO TURN MEASURE COLUMN INTO YTDContent
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.
Tagged:
0