Solved

Output error with GI

Still trying to fully understand the workings of the GIs.

I have a GI that is working in our sandbox system, but when I create it in our live system, I receive the following error:

Any assistance on this would be greatly appreciated.

Userlevel 7

+19

Hi @KempOdell68 It seems you missed the Aggregate Function in the Results tab.

If this does not solve the problem, please share the XML format of the GI.

Userlevel 1

@Naveen Boga , here is the xml.

Kemp

Userlevel 5

@KempOdell68 I just reviewed your XML and observed that the issue is with Debit Amount Column.

Userlevel 7

+19

Hi, @KempOdell68 As I informed you earlier, please add the aggregate function i.e.SUM to the Debit Amount column, which will solve the problem.

Please find the screenshots for reference.

Sign up