Adding a total to Crystal Report converted from PLD

[Former Member]

Hi,

Using SAP Business One 8.82 PL 6 with Crytal Designer 2008.

There is a Trial Balance system report called "Periodic Trial Balance Sheet - CR (CA) (System)" which is a conversion from an old SAP B1 reporting tool PLD (Print Layout Designer) with the help of a tool Crystal Converter.

I need to add a total at the bottom below the 'balance' column for only accounts from P&L drawers i.e. Revenue onwards. I built a formula in detail section as follows:

IF ToNumber(LEFT({PLD__ITEMS.F_136},1)) IN [4,5,6,7,8]

THEN {PLD__ITEMS.F_139f}

ELSE 0

and then totalled this field at bottom, but it does not work.

I need help either making this work or any other easier way to get what I need.

Thanks,

Ajay Audich

[former_member183750]

Please post to Business One:

http://scn.sap.com/community/business-one/reporting-and-printing

- Ludek

SCN Moderator

[Former Member]

Have already done that but no replies.

Do I mark this as 'assumed answered' in this forum to close/cancel this thread?

[former_member183750]

Sure.

And thanks

- Ludek