Forum Discussion
Post PatronIf column has specific charge mark record
You need to define OffForm as a calculated column in V_ACCT_CHARGES rather than as a measure.
Solution SpecialistAre 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) > 0in your formula.
Post PatronI 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
You need to define OffForm as a calculated column in V_ACCT_CHARGES rather than as a measure.