How to make a count on expression based on a formula

pashok75 — Thu, 23 Nov 2017 07:30:27 GMT

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

Re: How to make a count on expression based on a formula

Anil_Babu_Samineni — Thu, 23 Nov 2017 07:33:44 GMT

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)