Hi Rich,
Try this please:
1. Create a formula called @GroupSum with this code:
{@JanM} + {@FebM} + {@MarchM} + {@AprilM} + {@MayM} + {@JuneM} + {@JulyM} + {@AugM} + {@SeptM} + {@OctM} + {@NovM} + {@DecM}
2. Insert a Summary on this formula field and place it on the Group Header/Footer
3. Use the Group Sort Expert to Sort of this Summary field.
-Abhilash
Thanks so much Abhilash.
The monthly formulas look like this. Example {@JanM}:
If NumericText ({@Monthly Count Jan})
Then ToNumber ({@Monthly Count Jan})
Else 0
And the {@Monthly Count Jan} formula looks like this:
if {PTS_1_18_13_10_09.Entry Date/Time} >= DateTime (2017,01,01)
and {PTS_1_18_13_10_09.Entry Date/Time} < DateTime (2017,02,01)
then "1"
else "0"
Thank you!
Hi Rich,
You cannot group sort on such formulas.
Could you post the logic used in one of the month formulas?
-Abhilash
Add comment