To trim the Decimals off when using totext you add a ,0 after the number field so it would be:
"No. of orders for " + GroupName ({MAIN_FUND.XCODE}) + " : " + totext(Count ({LIX.ID}, {MAIN_FUND.XCODE}),0)
The "Never" option was in reference to a Running Total (rather than the formula variable field). When creating a Running Total the last item you identify is when to reset the the number back to 0 (the same process as your variable @reset_subtotal is needed to reset your varibale back to 0).
If in a Running Total you indicate it as reset as Never you will get a grand total for the entire report (assuming you place this RT field in the report footer
).
It is not needed if you use a variable process instead of a RT. However you would need a new variable for your total sum that you are not resetting at each group level 2.
Let me know if you need any more help.
IP Logged
