2 numbervar additions in 1 if statement? 1

[ITCPhil]

Hi,

I am wondering, is it possible to say something like :
if {@initial} = "BlaBla" then i:= i+1 AND j:=j+1 else
if {@initial} = "bleble" then l:= l+1 AND j:=j+1 else...;

For some reason, I can't get an accurate grand total so I thought maybe I could just put the j in every declaration to get a grand total that way but it results in an error message saying I require a boolean.

Thanks in advance,
Phil

 

[lbass]

If you are trying to create a group subtotal as well as a grand total, then use formulas like this:

//{@resetgrptot} to be placed in the group header:
whileprintingrecords;
numbervar grpsum;
if not inrepeatedgroupheader then
grpsum := 0;

//{@accum} to be placed in the detail section:
whileprintingrecords;
numbervar grpsum;
numbervar grtot;
if {@initial} = "BlaBla" then
(
grpsum := grpsum + {table.amt};
grtot := grtot + {table.amt}
);

//{@displaygrptot} to be placed in the group footer:
whileprintingrecords;
numbervar grpsum;

//{@displaygrtot} to be placed in the report footer:
whileprintingrecords;
numbervar grtot;

Not sure why you need variables. If you are using a condition, then you could create a formula like:

if {@initial} = "BlaBla" then {table.amt}

Then right click on this formula in the detail section and insert a summary and a grand total. If you don't have record inflation, and if {@initial} doesn't contain a summary or a function like next or previous, then this should work.

-LB

 

[ITCPhil]

Thanks, but I don't think that will work in my case. It's my fault however as I did not post all of the formula so it might not have been clear. The only group in the report is the date recorded, the data is all calculated with formulas. There is a left outer join in the report and I calculate 3 things, incidents initially assigned to a group, incidents that were there by interim and incidents resolved by a group.

I've a number of global variables (just over 70)that are used to calculate the results.

This is what the initially assigned looks like (I removed parts of it as it was a bit longer):
whileprintingrecords;
numbervar nt;
numbervar unix;
numbervar uas;
numbervar totalx;
if {@initial} = "MCT-ITC-SSMR-NT.R2" then nt:=nt+1 else
if {@initial} = "MCT-ITC-SSMR-UNIX.R2" then unix:=unix+1 else
if {@initial} = "MCT-ITC-UAS.R2" then uas:=uas+1;
totext(nt,0,"") & chr(10) &
totext(unix,0,"") & chr(10) &
totext(uas,0,"") & chr(10) & chr(10) &
totext(totalx,0,"") & chr(10) ;

totalx is what won't always add up properly, it comes off by one. It is calculated like so in another formula:
global numbervar totalx ;
if {@initial} in "MCT-ITC-SSMR-NT.R2","MCT-ITC-SSMR-UNIX.R2","MCT-ITC-UAS.R2"]
then totalx := totalx+1

This is why I was wondering if I could go
if {@initial} = "MCT-ITC-SSMR-NT.R2" then nt:=nt+1 AND totalx:=totalx+1
I wanted to get a correct total.

As to initial, it does contain previous, sorry about that lack of details. It checks 3 conditions, if an incident was never reassigned, if it was reassigned once, or if it was reassigned multiple times.

Clear as mud? Not an easy one to work with.
Phil

 

[lbass]

You could just add it into the current formula by using:

numbervar nt;
numbervar unix;
numbervar uas;
numbervar totalx;
if {@initial} = "MCT-ITC-SSMR-NT.R2" then nt:=nt+1 else
if {@initial} = "MCT-ITC-SSMR-UNIX.R2" then unix:=unix+1 else
if {@initial} = "MCT-ITC-UAS.R2" then uas:=uas+1;
if {@initial} in ["MCT-ITC-SSMR-NT.R2","MCT-ITC-SSMR-UNIX.R2","MCT-ITC-UAS.R2"]
then totalx := totalx+1

totext(nt,0,"") & chr(10) &
totext(unix,0,"") & chr(10) &
totext(uas,0,"") & chr(10) & chr(10) &
totext(totalx,0,"") & chr(10) ;

Be sure that you have a separate display formula for the report footer like:

whileprintingrecords;
numbervar totalx;

...so that you are not accumulating an extra value in the report footer.

-LB

 

[ITCPhil]

Thank you very much,
I will see how that works
Phil