06-20-2023 12:55 PM - last edited on 06-20-2023 02:15 PM by JackLacava
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 multiple children and would like use a where clause to exclude IsIC data. i tried to do A#P.Base(IsIC False) but this results in multiple lines where i would want to only have one line presented that is removing the data associated with the children that are IC. is there a function that would let me create a summary line while still checking the descendent configuration?
06-20-2023 02:55 PM
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)"
06-20-2023 03:28 PM
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 ?
06-20-2023 03:28 PM
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 ?
06-20-2023 03:46 PM
Sorry I don't have any information on that. For member formulas we can have a formula for calculation drill down but in a spreadsheet for an XFBR rule I don't know how this can be done.