Skip to Content
avatar image
Former Member

SAP Crystal Sum Formula

Hello All,

I have following scenario of grouping one of Crystal report (SAP Crystal for Enterprise)

I want to calculate ‘EARNING BEFORE TAX’ at report footer which Sum of all the earnings (i.e. Group 3 values) Minus Total Taxation.

I mean EARNING BEFORE TAX=NET EARNING – Total Taxation.

Could you please help me with the formula for the same.

Current I’h just used running total and kept it at the Report Footer which is summing up everything (Similar to NET EARNING).

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 20, 2017 at 09:28 AM

    Kindly Help

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20, 2017 at 09:43 AM

    Use a formula which excludes tax eg

    If type NOT( in [Taxation, Withholdingtax]) then value field else 0

    replace fields and descriptions as appropriate for your report, use this in your Running total.

    Ian

    Add comment
    10|10000 characters needed characters exceeded

    • You cannot use a groupname in this formula if you want to do a summary or RT on it.

      Try

      If NOT({ECC_IFSC_PRD_UNI.IFSC Infoset for Reporting\Account Number} in ['Taxation']) then {@Balance Ledger} else 0

      This assumes @BalanceLedger does not contain any summaries too

      Ian