Jump to content
  • 0
Farnsbarnes

Grouping by calculated field

Question

Can't seem to find any previous references to this.

In my tabular report one of my fields is a calculated field that outputs text (don't ask... it had to be done this way)!

Each record in this calculated field contains a region (ie Europe, N.America, etc)    My other 'normal' fields cover a range of text and numbers

What I want to do is display the whole table grouped in terms of the regions in the calculated field, rather like having a 'total and aggregation' for the calculated field.

I've tried adding the calculated field in the 'total and aggregation' option, but just get an error when trying to display the table

Any help very welcome.  Thanks!

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

I suggest that instead of using a calculated field, create an extra field on your table and use triggered actions to perform the calculation for you. Since it is a normal field, you should be able to group your values from it.

Share this post


Link to post
Share on other sites
  • 0

@Shiro

That  will still depends on what is the calculation they are doing. There are chances that their formula is cannot be converted into triggered action. In my experience, TA is not that good on handling decimal values. They automatically round them off.

Share this post


Link to post
Share on other sites
  • 0

Thanks for the responses.

Unfortunately I don't think I have any alternative to allocating the regions at runtime.  This is because the User has up to 50 different regions which can be selected and countries can overlap.  For example, a User could select 'EU27' or 'Western Europe', or 'Europe', etc.     France, for example, falls into all those regions.  But if the User selects 'Europe', then that's the region I want to assign next to the record with France in the calculated field.  If he selects 'EU27', then it's that region that I want to assign next to the record with France in the calculated field, and so on.

Any other suggestions most welcome!

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...