Forum Discussion

SamuelGorgonio's avatar
SamuelGorgonio
New Contributor II
2 years ago

Summarizing a member expansion so it appears as a single row in Quickview

I am trying to create a quickview that would require the data presented to consider some account configuration that only appears on the decendents set up.   ex i have a parent member P that has m...
Excel Add In
Reports
Omkareshwar's avatar
Omkareshwar
Contributor II

Hi Samuel,

You can use this XFBR Rule just update the highlighted part as per your requirement and it will return a string 

"GetDataCell(E#E1 + E#E2 + E#E3)" so you'll get a sum in a single line 

Syntax to call xfbr functions "XFBR(businessRuleName, brFunctionName)"

 

If args.FunctionName.XFEqualsIgnoreCase("GetSumMemberGetDatacell") Then
 
Dim entityList = BRApi.Finance.Metadata.GetMembersUsingFilter(si, "FinBU1", "E#TotBU1.Base.Where(Text1 Contains '39000')", False)
Dim entityGetDataCell As String = ""
For Each entity As MemberInfo In entityList
entityGetDataCell = $"{entityGetDataCell} + E#{entity.Member.Name}" 
Next
 
' Remove the leading " + " if present
If entityGetDataCell.StartsWith(" + ") Then
entityGetDataCell = entityGetDataCell.Substring(3)
End If
 
Return $"GetDataCell({entityGetDataCell})"
 
End If
 
Thanks, Omkareshwar
Archetype Consulting
SamuelGorgonio's avatar
SamuelGorgonio
New Contributor II
2 years ago

Do you know if when utilizing the Business rule method its possible to drill down to detail as you would with a regular line item. I noticed that when i use gedatacell the drill down only shows the getdatacell formula and does not allow you to drill down on dimensions ?