How to restrict a record of which both field fall in to same month

[nevilledhamsiri]

Hi,

Please see the data attached & help me to restrict records of which  Cr Month equal to From Month from being shown. How aggr (only  function is deploy able for satisfying two fields?

Many thanks in advance

Neville

[sunny_talwar · Accepted solution]

May be this

If(CR_MONTH <> FROM_MONTH, Sum(PREMIUM))

[nevilledhamsiri]

Thanks sunny,

As I applied it, Premium due to Jan was excluded. What to be done to exclude that entire record

RA00	FR	Jan	Sep	RA0014DF0001457	7500	7500
			Nov	RA0017CF0001418	4700	4700
	M4	Jan	Jan	RA00144X0000243	5242.12
			Dec	RA00174F0000540	11028.75	11028.75
	MC	Jan	Jan	RA00141D0003731	37775.66
				RA00171A0002924	25460.16
				RA00171A0002929	93373.75
				RA00171A0002947	12403.13
			Jul	RA00171A0002878	39535.05	39535.05
			Aug	RA00161X0002327	6504.86	6504.86
				RA00171C0003296	23640.91	23640.91
			Sep	RA00121D0003250	2178.34	2178.34
			Oct	RA00141D0003735	15101.44	15101.44
			Nov	RA00151X0002087	10672.5	10672.5
				RA00171A0002932	62135.48	62135.48
				RA00171C0003326	13110.94	13110.94
			Dec	RA00151B0005870	9286.99	9286.99
	TC	Jan	Sep	RA0016TC0002723	66125	66125

[sunny_talwar]

Are you using two expressions? Remove the first one

[nevilledhamsiri]

Yes Sunny, Very sorry. Once removed it, it became alright

Thanks a lot