Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  How to add boolean variable in list

    Posted Wed September 22, 2021 07:58 AM
    Hi All,
    I need to add boolean variable in list as showing that if Amount>10000 then it will show otherwise not
    how to add that.


    and can anyone please let me know syntax of if statements in Framework manager

    ------------------------------
    Priyanka Joshi
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: How to add boolean variable in list

    Posted Wed September 22, 2021 09:19 AM
    Hi Priyanka,

    I guess you could create a calculation with the following. Let's assume your data is about Amount, you will create a "fake Amount" with:
    if ([Amount] < 10000) then (0) else ([Amount]).

    Add "fake Amount" in your list instead of "Revenue".

    You will need to change the format regarding zero value characters.

    Best regards,

    ------------------------------
    Patrick Neveu
    Consultant
    Positive Thinking Company
    Paris
    ------------------------------

    Original Message