Skip to Content
0

SAP Crystal Sum Formula

Sep 20, 2017 at 09:27 AM

41

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

Kindly Help

Share
10 |10000 characters needed characters left characters exceeded
Ian Waterman Sep 20, 2017 at 09:43 AM
0

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

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

When use this formula 'type' got red underline and error says

"A number, currency, date etc. is expected here"

I wrote below formula

If type NOT( in ['Taxation', 'With-Holding Tax']) then {@Balance Ledger} else 0

0
Former Member

Also these are not the only 2 groups in the report. There are around 15-20 groups.

0

Replace Type with your field which defines the descriptions 'Taxation', 'With-Holding Tax'.

These are setting those values to zero for your running Total if there are other types that should be excluded you will need to add them to list.

Ian

0
Former Member

Thanks Ian,

I'm still facing 2 issues in this.

1) I used below formula

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

here NOT is red underlined and error msg is saying 'then' is expected here.

2) this formula is not available in drop down when I'm trying to create running total on it.

Thanks.

0

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

0