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 SpecialistProbably in the table with the charges. I assume that table also has a column for ACCTNUM that connects the two tables?
Post PatronYes it does
- erik_tarnvik
Just to be clear, you could put the new column in either table. If you put it in the main account table you would have to modify the FILTER formula but it would still work and actually be somewhat more efficient. But it depends on how you are going to use it which I can't really tell.
- kattlees
How I want to use it is to who a line and cluster column chart that shows the total charges of a case that is considered "special" with the number of cases done
Then another one that shows the same thing with cases that are not considered "Special"