Sorting a report by the results of an "If" function
I am trying to sort a report by the results of an "If" function.
"If" field is called mediaSort = If ( BuyNumbers::media="Radio"; RadioMetros::metro; DMA::DMA)
Result field is called mediaSortResult
I tried two methods:
1) Created a Set Field mediaSortResult; MediaSort]
2) Set mediaSortResults as a calculation = Unstored, =mediaSort
Then I sorted the report on the mediaSortResutls field
Both methods fail. Any clues why?