cancel
Showing results for
Did you mean:
Established Member

## Re: If column has specific charge mark record

Are you searching for records where V_ACCT_CHARGES[ChargeDescription] is exactly equal to "KNEE MED I" or just records where V_ACCT_CHARGES[ChargeDescription] contains "KNEE MED I" but may also include other text? If the latter, replace

`V_ACCT_CHARGES[ChargeDescription]="KNEE MED I"`

with

`FIND("KNEE MED I", V_ACCT_CHARGES[ChargeDescription],1,0) > 0`

Member

## Re: If column has specific charge mark record

Where it is exact. Let me try your formula

Member

## Re: If column has specific charge mark record

I get this error

A single value for column 'AcctNum' in table 'V_ACCT_CHARGES' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

My formula is this:

OffForm = IF(COUNTROWS(FILTER(V_ACCT_CHARGES,V_ACCT_CHARGES[AcctNum]=EARLIER(V_ACCT_CHARGES[AcctNum]) && V_ACCT_CHARGES[ChargeDescription]="KNEE MED I"))>0,1,0)

Do I need to use the V_ACCT table where the acct number is only listed once?

Established Member

## Re: If column has specific charge mark record

You need to define OffForm as a calculated column in V_ACCT_CHARGES rather than as a measure.

Member

## Re: If column has specific charge mark record

Sorry if this is a dumb question, but how do I do a calculated column? I right clicked on the table name and chose create new column and put the formula in.  I didn't choose measure.

Member

## Re: If column has specific charge mark record

I was in the wrong table. Sorry.  It worked perfectly