Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Using IN-GROUPS-OF in a hold file leads to an additional tile


Denis Ribaud

Recommended Posts

Hi there,

we create a hold file with the IN-GROUPS-OF and then use the hold file to create a report with accross. As we are using IN-GROUPS-OF 10 tiles we have 10 tiles in the resulting hold file:

TABLE FILE TABLENAME

SUM MEASURE

BY MEASUE IN-GROUPS-OF 10 TILES

BY TIME

ON TABLE HOLD

END

But when aggregating this hold file with the following code:

TABLE FILE HOLD

SUM MAX.MEASURE

ACROSS TILE

BY TIME

ON TABLE PCHOLD FORMAT XLSX

END

we get an additional tile 11 for some rows. How do we prevent the additional tile 11 to be created

Any hint appreciated.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...