0

# Formula on grand total in crystal reports. How to do this?

May 15 at 08:24 AM

32

Hello All,

I have a CR4E report and the data looks like below. Need to calculate on Grand Total. How?

HOA Amount

0070-01-102-00-01-000-000 175,500.00

0070-01-102-00-01-000 175,500.00

0070-01-102-00-01 175,500.00

0070-01-102 175,500.00

0070 -MH 175,500.00

0035-00-101-00-01-001-000 320,350.00

0035-00-101-00-01-001 320,350.00

0035-00-101-00-01 777,039.00

0035-00-101 777,039.00

0035 -MH 777,039.00

I need to write the formula on MH = grand total.. how to write the formula for this

Can anybody help?

Ian Waterman May 15 at 09:45 AM
0

Create a formula

@MH

If Right(HOAField ,2) = 'MH' then AmountField else 0

YOu can then add a summary on this Formula in either Group or Report footer

PS if MH is not always the last 2 characters change formula to

If HOAField like '*MH*' then AmountField else 0

Ian

Share
Abhilash Kumar
May 15 at 09:36 AM
0

Please provide more details and elaborate on "I need to write the formula on MH = grand total."

An example of what you need would be helpful too.

-Abhilash

Show 2 Share

Hello Abhilash,

I need to write the formula only on MH value that is last 4 digit. The HOA has some value and with some amount.

MH - 0070 175,500.00

MH - 0035 777,039.00

I need to make a grand total on MH. but how do i segregate the value which is already in hierarchy.

Thanks

Hello Abhilash,

HOA Amount

0070-01-102-00-01-000-000 175,500.00

0070-01-102-00-01-000 175,500.00

0070-01-102-00-01 175,500.00

0070-01-102 175,500.00

0070 53000.00

I need to calculate only 0070 value..How to write the formula for this.

Thanks