maximum number out of a list
Content (please ensure you mask any confidential information):
im trying to use @max essbase function but it is erroring out with this message. Cannot calculate. Essbase Error(0): Error executing formula for [OFS_Calculated] (line 0): invalid object type
Scenario is based on the rank provided, for the last ranked account to pass a value lets say for ex : 100. 100 should be there in the account "3711597" in APR FY24 column instead of -282052.
Rank is created as a member in the plan element dimension.
Tried it in different way it didnt work.
Version (include the version you are using, if applicable):