Sum in Report derived from an expression (1 Viewer)

thudson

Old Programmer
Local time
Today, 20:19
Joined
Apr 29, 2011
Messages
68
I am trying to SUM the values for Profit in a report from a value derived using an expression. When try to create a Total, using Design Totals, Sum is greyed out.
Is there another way I can total these values. I have tried doing it in a Query but that was unsucessful.
 

June7

AWF VIP
Local time
Today, 11:19
Joined
Mar 9, 2014
Messages
5,466
I've never used Design Totals on report (never even noticed it was there). Just now looked at and Totals is greyed out. Oh, only available in Layout view. I seldom work with Layout view. Arithmetic functions only available if a number value is in the textbox. What is the expression generating value?
 
Last edited:

Users who are viewing this thread

Top Bottom