Set Analysis Filtering by the product of two fields
Hi,
I am trying to filter on the product of two fields - I want to look for the count of claim_id's where unit_price * quantity is greater than $150. The fields unit_price and quantity exist in different residents/tables. I realize I could calculate this in the data load but wanted to know if it's possible to accomplish this in set analysis.
Normally I'd filter one field, like this:
count(distinct {<quantity ={">150"}>} claim_id)
But I'm trying to do the above, with unit_price * quantity ">150"
Within a classical set analysis it's not possible because it's a column-level evaluation and here you need a row-level evaluation. It's often possible to include such stuff within a set analysis syntax but logically it's then an if-loop. Therefore why not using one like:
Moving the measure-fields into a single-table and doing there such calculation within extra fields may create significantly benefits in regard to the easiness of UI developments as well as to the performance.
Within a classical set analysis it's not possible because it's a column-level evaluation and here you need a row-level evaluation. It's often possible to include such stuff within a set analysis syntax but logically it's then an if-loop. Therefore why not using one like:
Moving the measure-fields into a single-table and doing there such calculation within extra fields may create significantly benefits in regard to the easiness of UI developments as well as to the performance.
