cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
erik_tarnvik Established Member
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

in your formula.

 

kattlees Member
Member

Re: If column has specific charge mark record

Where it is exact. Let me try your formula

 

kattlees Member
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?

erik_tarnvik Established Member
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.

kattlees Member
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.

kattlees Member
Member

Re: If column has specific charge mark record

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