How to make a count on expression based on a formula

[pashok75]

Dears,

I have one scenario wherein I need to get a count based on the following

N - 10

R - 5

C - 2

The formula to get the count will be (N + R - C)

(Count(DISTINCT{<T_PREM_TYPE={'N','R'}>}, T_POL_NO))- Count({<T_PREM_TYPE={'C'}>}, T_POL_NO)))

The values N, R, C is T_PREM_TYPE

T_POL_NO is the field value i need to do the sum.

Ashok

[Anil_Babu_Samineni · Accepted solution]

Expression, Wrong with extra comma, May be this?

Count({<T_PREM_TYPE={'N','R'}>} T_POL_NO) - Count({<T_PREM_TYPE={'C'}>} T_POL_NO)