Skip to Content

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 15 at 09:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 15 at 09:36 AM

    Hi Radhika,

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

      Radhika

  • May 15 at 04:32 PM

    Create a formula like this:

    if InStr({Mytable.HOA}, 'MH') > 0 then {MyTable.Value} else 0

    You can then sum this formula to get your value.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded