Former Member

### Suppressed amount is included in Running Total

Dear Everyone,

I am doing report for vatable amount.

In my report, withholding tax for 1% and 5% is separated, my problem is when it generates and both 1% and 5% has value, it generates to rows with the same value except for the withholding tax.

I have created a formula in "suppress" to eliminate the double amount in vat and other amount value details.

{INV5.WTCode} = "CW5"

it does suppress the amount, but the problem is that the running total is including the suppressed amount.

What should I do to make the running total not to include the suppressed amount.

I read a discussion with similar case and tried going thru it but I am a bit confused.

thanks,

10|10000 characters needed characters exceeded

• Oct 22, 2015 at 11:36 AM

Hi Florencio,

Edit the Running Total > Under 'Evaluate' choose 'Use a formula' and use this code:

{INV5.WTCode} <> "CW5"

-Abhilash

10|10000 characters needed characters exceeded
• Former Member
Oct 23, 2015 at 01:10 AM

Dear Sir,

I have followed your instruction but it is not computing other vat.

vatable sum.jpg (288.3 kB)
10|10000 characters needed characters exceeded
• Former Member
Oct 23, 2015 at 01:27 AM

Sir,

If you can notice I am only concentrating on the vat and not the other computation coz if I can resolve the vat sum problem then I can apply it to the rest of the running total.

Thank you very much

florencio.

10|10000 characters needed characters exceeded
• Do you have a better representation of 'I have followed your instruction but it is not computing other vat.'

-Abhilash

• Former Member
Oct 25, 2015 at 11:53 PM

Dear sir,

Sorry for the incomplete comment.

I have used {INV5.WTCode} <> "CW5"  formula in running total for Vat. It does compute the unsuppressed amount under the line or customers which has suppressed amount. But my problem is it is not computing the running total for customer which has no suppressed amount as shown in the picture that I have posted.

Vat formula is {OINV.DocTotal} - {OINV.VatSumSy}.

thank you.

10|10000 characters needed characters exceeded
• Former Member
Oct 27, 2015 at 01:45 AM

Dear sir,

I have tried below formula in Section expert under suppress.

WhilePrintingRecords;

If {@Vatable} <> (next{@Vatable}) OR OnLastRecord then

numbervar gsum := gsum + {@Vatable};

numbervar grand := grand + gsum;

);

it is giving message that ")" is missing.

10|10000 characters needed characters exceeded
• Try:

WhilePrintingRecords;

If {@Vatable} <> next({@Vatable}) OR OnLastRecord then

(

numbervar gsum := gsum + {@Vatable};

numbervar grand := grand + gsum;

);

-Abhilash

• Former Member
Oct 27, 2015 at 02:31 PM

Florenco,

When you "Supress" a field it only means it does not display on the report.  Surpressed  is not the same as excluded.

....    so yes,  Crystal is working the way it is supposed to work .... the value of a suppressed field IS included in the running total.     That is how it was intended to work

The value of the field will still be included in a running total   ( even if it is surpressed ).

What you need to do is write the Formula in the running total in a manner so that the value you supressed is not included in the results of the formula.    That's what Abhilash is tring to accomplish with his suggestions.