Forum Discussion

NicoleBruno's avatar
NicoleBruno
Valued Contributor
4 years ago

Max/Min Calculation Row in CV

Hello! 

I received a request to add a maximum and minimum line to a cube view. The cube view shows entities in columns and a variety of accounts in the rows (not together in a hierarchy, so no .base or .children, just a list separated by commas). 

Max/min aren't available in the "getdatacell expressions" area so I emailed support to see if it's possible and they directed me to a ranking BR in GS. I loaded the BR, added a row to my CV and updated the pull but still am getting no data. Honestly, I don't think this BR and pull are the solution for what I'm trying to do but I don't know of any other way. 

Do any of you have samples of pulling something similar? Were you able to get a max and min in a CV via CV math or some other way? 

Appreciate any help I can get - thanks! 

Here's the KB article provided for reference: 

 

And the GS CV is in CVs > XFR Member filters (E) Member list using business rule > XFR Member List (C) Ranked Entity Sales.