3 Replies Latest reply on Apr 29, 2018 12:40 PM by Okechukwu Ossai

    Calculated field of different measures based on parameter not sorting

    laurie mcconville

       

      Hello:

       

      I have a calculated field that is a product of several fields based on the parameter chosen  That is, the parameter is used in a case statement to then choose which field is displayed in the calculated field.

       

      For some reason when I sort on this calculated field, it seems to be sorting improperly, like something in the background is affecting the sort invisibly.

      For example, when I sort on Total percent failed descending (first pic) ir works.

      When I change the parameter to count of grades rather than percent, it does not work (second pic).

       

      I have a similar issue with another dashboard where none of the sorts seem to work for my parameter based calculated field.