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.

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

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

Caroline Blanchard

It does not return the expected value @Mallikarjuna Kuppauru-Oracle . Thanks for getting back to me so quickly!

Mallikarjuna Kuppauru-Oracle

Hi @CarolineAnderson

Is your logical query is returning correct value?

Pass the filter value directly and then test see are you able to get the expected value instead of passing @parameter

Regards,

Arjun