Oracle Communities

Oracle Analytics and AI

Child Item

Can Parameter values be used in custom calculations?

Caroline Blanchard

We would like to create a custom calculation that filters a measure by the year number in a parameter.

This parameter will enable us to see data in the ending balance of previous years.

We set up our Fiscal Year parameter in the image above.

The calculation validates, however it does not return the proper values. Any advice or input on this topic would be very much appreciated.

Find more posts tagged with

Parameter

Customizing Reports

FDI

Fusion AI Data Platform

Accepted answers

Raghavendra Raghunath-Oracle

Hi @CarolineAnderson @Mallikarjuna Kuppauru-Oracle I had a similar calculation built in HCM and it does work. I also validated it against the seeded headcount metric with year as filter. The formulas i had was as below

Current HC - IFNULL(FILTER("HCM - Workforce Core"."Facts - Workforce Headcount"."Headcount" USING "HCM - Workforce Core"."Time"."Year" = @parameter("Period Year")(1111)) , 0)

Previous HC - IFNULL(FILTER("HCM - Workforce Core"."Facts - Workforce Headcount"."Headcount" USING "HCM - Workforce Core"."Time"."Year" = (@parameter("Period Year")(1111)-1)) , 0)

The query for the parameter initial value was as below

Period Year - SELECT "HCM - Workforce Core"."Time"."Year" FROM "HCM - Workforce Core" WHERE (("Time"."Year" IN (YEAR(CURRENT_DATE))))

Raghu

All comments

Mallikarjuna Kuppauru-Oracle

Hi @CarolineAnderson

As per screenshots your syntax is correct, "however it does not return the proper values" --> means you not able to see the expected value?

Regards,

Arjun