I have reviewed other posts and learned that the way to get a total to print based on formula fields is to add several "whileprintingrecords" formula fields - one to clear the variable in the header - one to accumulate the total in the detail - and one to assume the total value in the footer.
I have tried to establish such a setup using Crystal 8.5 in an inventory report which has a formula field which computes a LIFO value on each detail line which is often zero.
I have a header level formula which is :
whileprintingrecords;
numbervar LTX;
LTX = 0
And a detail line formula which reads
whileprintingrecords;
numbervar LTX;
LTX = LTX + LIFOVAL (the formula field)
and then the footer formula as:
whileprintingrecords;
numbervar LTX;
LTX=LTX
The problem I am running into with this is that the detail line formual insists on being a boolean - so, my detail line includes "true" and "false" only - never a value
and, the total level is always zero.
I have tried to establish such a setup using Crystal 8.5 in an inventory report which has a formula field which computes a LIFO value on each detail line which is often zero.
I have a header level formula which is :
whileprintingrecords;
numbervar LTX;
LTX = 0
And a detail line formula which reads
whileprintingrecords;
numbervar LTX;
LTX = LTX + LIFOVAL (the formula field)
and then the footer formula as:
whileprintingrecords;
numbervar LTX;
LTX=LTX
The problem I am running into with this is that the detail line formual insists on being a boolean - so, my detail line includes "true" and "false" only - never a value
and, the total level is always zero.