AnsweredAssumed Answered

Sorting a report by the results of an "If" function

Question asked by KurtSnow on Apr 26, 2013
Latest reply on May 7, 2013 by KurtSnow

Title

Sorting a report by the results of an "If" function

Post

     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?

Outcomes