Search results for query: *

Seems like we have looked this over pretty good and it just doesn't work. Maybe it has to do with the passes. I'll just try to work around it. Thanks for your input!

Yes, a summary of {@ENCUMBRANCE AMT} is in the group footer of {@Document}. I can see that summary field in the Fields list of the Formula Editor. The formula {@Document} is if {FR_HX_REPOS.XACTION_CD} = "210" then {FR_HX_REPOS.CURR_DOC_CD} else {FR_HX_REPOS.REF_DOC_CD}

Below is the formula for {@ENCUMBRANCE AMT}. IF {FR_HX_REPOS.COMPTR_GEN_LEDG_CD} = ["9001", "9002"] THEN {FR_HX_REPOS.XACTION_AMT} ELSE 0 I can place {@ENCUMBRANCE AMT} in the detail section and insert a summary that shows under the magnifying glass as Sum of @ENCUMBRANCE...

Now the first formula is exactly as below, but still the error message !The summary/running total field could not be created appears. WhilePrintingRecords; numberVar Test; if Sum ({@ENCUMBRANCE AMT},GroupName ({@Document}))<>0 then Test:=Test + Sum ({@EXPENDITURE AMT},GroupName ({@Document}) )

The {@Encumbrance Amt} field is a number. I cannot right click on the field and insert a subtotal, but I can insert a summary in the group. When creating the 1st formula I had to use quotes around the 0 to get rid of the error message &quot;expecting a string&quot;. There is a whole group of...

Thank you for answering this question. I got little error messages when I was creating the first formula which ended up exactly as below before I got the message !The summary/running total field could not be created. WhilePrintingRecords; numberVar Test; if Sum ({@Encumbrance Amt}, GroupName...

I am trying to use two running totals in a group and have the amounts for one not be included in the report totals when the other running total for the group = 0.00 I used group selection and this formula Sum({Encumbrance Amt})<>0.00. Currently these groups are not showing on the report, but...