Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am trying to implement filter condition but it shows error in expression.
Can anyone help me to identify error.
='Point (' & Count(Distinct [Point Name]) & ')' & If(GetSelectedCount(< System_Type =('Meter') > [Point Name] > 0, '', '')
giving error on last bracket
indeed one bracket is missing
but is Syntax correct?
try this
='Point (' & Count(Distinct [Point Name]) & ')' & If(GetSelectedCount({< System_Type =('Meter') >} [Point Name]) > 0, ', ')
Hi Rudolf,
I tried the same expression what you have mentioned. it shows below error
Use
='Point (' & Count(Distinct [Point Name]) & ')' & If(GetSelectedCount([Point Name]) > 0 and System_Type ='Meter','','')
Hi Pankaj,
Can you try this process
='Point (' & Count(Distinct [Point Name]) & ')' & If(Count({<System_Type ={'Meter'}>}[Point Name])>0, '', '')
try to enclose System Type with [System Type]
Syntax is correct and brings data in my case (without your fieldnames)
='Point (' & Count(Distinct [Point Name]) & ')' & If(Count({<[System_Type] ={'Meter'}>}[Point Name])>0, '', '')