Skip to Content
avatar image
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.

Can some help me please.

thanks,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • 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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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.


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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.   

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Sir Ted,

      Thank you for your explanation. Yes sir, I do understand that Crystal is doing what it supposed to do. I have seen Sir Abhilash suggestion in the other thread and I am trying to follow it one by one. When my formula didn't work that is the time I posted a query.  Sorry if I may sound dumb, I am new to crystal and I would really like to learn it. That is why I am having a refreshing course in Programming Logic Formulation so that I could again understand the different Boolean that is being used in formulas.

      Thank you for your usual support.

      Florencio