Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | - |
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