161407 - no subject - Hi,\n\nI have created a new report view

paulr866 over 9 years ago

Hi,

I have created a new report view and I have some split columns called day,week,month, and year and i'm having trouble getting it to function with my radio buttons. i'm getting the following error

Could not display interface. Please check definition and inputs.

Interface Definition: Expression evaluation error at function a!queryAggregationColumn [line 67]: The a!queryAggregationColumn function has an invalid value for the “aggregationFunction” parameter. When “isGrouping” is null or false, “aggregationFunction” must not be null or empty.

I have inserted the following query. Can you advise what 'm doing wrong?

a!queryAggregationColumn(
field: "DayPart",
isGrouping: if(
rule!APN_isEmpty(
local!groupByFilter
),
{},
a!queryFilter(
local!groupByFilter = "Day",
True(),
False()
...

Discussion posts and replies are publicly visible

0 paulr866 over 9 years ago

... )
)
),

The above rule used is if(fn!isnull(ri!array),true(),length(ri!array)=0)

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 matthewb85
A Score Level 3
over 9 years ago

Paul,

isGrouping in this case requires you to pass in an aggregationFunction if isGrouping is null, which seems to be the case based on the error. You will need to include a value for that in the case you get a null value for "isGrouping".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel