GET A ZERO VALUE

[sagaraperera]

DEAR ALL

All I want to do is use the EXPRESSION below to get values that have only a value zero.

                                                        expression -     SUM(ACTUAL)

NOTE_DESC	MC
STAFF SALARIES	2
CONTRACT WAGES	25
EPF	2
ETF	25
PENSION FUND CONTRIBUTION	-
GRATUITY	2
MEDICAL FUND	25
INSURANCE - STAFF	2
ANNUAL BONUS	25
SPORTS CLUB	2
STAFF WELFARE	25
INTEREST REBATE ON HOUSING LOANS	-

[vchuprina]

Hi,

As I understood you want to show sum of Actual where MC is null or empty or -. if so you can use the following expression:

SUM({$-<MC-={'*', '-', ''}>}ACTUAL)

Regards,

Vitalii