Data Grouping option is not available in some formulas

[CapNcook]

Hi,

I have an issue where some of my formulas are avaible in to group and some are not

For example I have this formula [@field:Firstname] +space(1)+[@field:LastName] and I cant group my reports with this field but with my other formulas such as field1+field2 it's available. Anyone encounter this issue?

[ianGPT]

Hi,

I think the issue is in the size of the field. The grouping is not allowed for long text. You can try converting your formula to varchar 255. 

Example:

cast([@field:First_Name]+Space(1)+[@field:Last_Name]+','+Space(2)+[@field:Address_1] as nvarchar(255))

Hope this helps!

[Merikirin]

Hi @CapNcook,

You can also find more information about formulas in Caspio by checking out this link: https://howto.caspio.com/function-reference/

[Queso]

Hi everyone, just wanted to share as well that we cannot use Data Grouping in unique IDs, Files, Text(64000), and List data types.