Skip to Content
0
Sep 09, 2013 at 05:30 PM

Adding a total to Crystal Report converted from PLD

89 Views

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