Skip to Content
0

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

May 15 at 08:24 AM

32

avatar image

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?

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

3 Answers

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
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
May 15 at 09:36 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

Radhika

0

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

0
Dell Stinnett-Christy May 15 at 04:32 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded