SUM of formula value in grop header
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22048
Printed Date: 24 Apr 2024 at 8:16pm
Topic: SUM of formula value in grop header
Posted By: jschussmuller
Subject: SUM of formula value in grop header
Date Posted: 09 Aug 2016 at 11:11am
Hello! I need a little help for this, I have this formula in my detail section:
Formula name= conteo
If {@Saldo2} <> 0 then 1 else 0
-----
And te @Saldo2 formula is like this:
Sum ({@Facturado}, {Comando.factura})-Sum ({@Cobrado}, {Comando.factura})
well, I need to have the sum of the formula "conteo" in the group header, I tried with the sum function but I get a message error "Este campo no se puede resumir". Any suggestions?
Sorry for my english! thanks
|
Replies:
Posted By: kevlray
Date Posted: 09 Aug 2016 at 12:23pm
The message translates to 'This field cannot be summarized' ,but of course it does not tell you which field cannot be summarized. So you need take pieces of your formula (put them in other formulas and check the results) with the sums and find out what it does not like.
|
|