MattRichardsUK
Technical User
I,m trying to pass the Maximum Value from a Running total, to a text box to display on my report.
My Formulae are as follows:
//RunTotal1
// Goes in group header for Agent Screen Name (group header #2a)
WhilePrintingRecords;
NumberVar Sessions:=0
//RunTotal2
//goes in detail section
WhilePrintingRecords;
IF {msi_tstamp.screen_name} = {msi_tstamp.rep_screen_name} then
NumberVar Sessions:= Sessions + 0
ELSE
NumberVar Sessions := Sessions + 1;
I want the maximum value 'RunTotal2' to be displayed in the text box. The Formula editor will not allow me to create a new formula field, displaying the error message.
"The summary / running total field could not be created"
Any suggestions?
My Formulae are as follows:
//RunTotal1
// Goes in group header for Agent Screen Name (group header #2a)
WhilePrintingRecords;
NumberVar Sessions:=0
//RunTotal2
//goes in detail section
WhilePrintingRecords;
IF {msi_tstamp.screen_name} = {msi_tstamp.rep_screen_name} then
NumberVar Sessions:= Sessions + 0
ELSE
NumberVar Sessions := Sessions + 1;
I want the maximum value 'RunTotal2' to be displayed in the text box. The Formula editor will not allow me to create a new formula field, displaying the error message.
"The summary / running total field could not be created"
Any suggestions?