12 Replies Latest reply on Nov 6, 2017 10:11 AM by Joel Acha

    Display Measure values when contain negative value


      Hi all,


      I have a requirement where in my report should display results based on dashboard prompt values.

      For example, a dashboard prompt which should contain values "ALL" and "Contain Negative".

      When the user selects "ALL" in DB prompt then my report to display all the values (both +ve and -ve measure column values).

      If i select "Contain Negative" (if my measure values contain at least one -ve value) then my report should display measure column values (both +ve and -ve values), here if all the +ve all there then it should not show anything.