Joined: 17 May 2017
Online Status: Offline
Posts: 1
Topic: Formula Fields Not Showing as Grouping Option Posted: 28 Jun 2017 at 3:32pm
Hi Guys,
I am having a problem grouping on a specific formula field. For some reason, when I create a new formula field, even before any code has been entered into it, no new formula field will show up as an available option to create a group on.
I've read that depending on the code that is inserted into the formula, it will show show up as an option to group on, but have never read what the criteria is, other than it cannot be a running total field.
Suffice it to say that the result of my field is very linear, in that it results in values based on IF-THEN statements that are very straight-forward. Yet it refuses to show up as an option to group on.
Any idea what's going on? I am using CR 2013 build 14.1.6.1702
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 29 Jun 2017 at 9:57am
The reason that a formula will not show up for grouping is because the formula contains a summary (or references another formula with a summary). A summary can be a sum, average, count, maximum, minimum,etc. There may be other cases, but that is the most common reason I can recall.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 03 Jul 2017 at 7:18am
also certain function use like previous()/next() would not allow for any grouping.
If you post your formula someone might be able to assist more directly as to what in that formula is preventing the group usage.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
