Governance, Risk, and Compliance (GRC)

 View Only
  • 1.  Calculation Question

    Posted Thu March 03, 2022 08:29 AM
    Hi All,

    We are experiencing issues while copying the values from a "Single select drop down" (parent) to a  "Multiselect drop down" (child) using calculations.
    Both the drop downs have identical values but the calculation is throwing null pointers specifically when the "single select" is blank.

    Adding the conditions on the calculations also don't help.

    Suggestion needed on how we can set the multi select to be blank when no value is selected on single select field.

    Following don't work
    if exists([$multiselect$]) then [$multiselect$] else '' endif
    if ([$multiselect$]!='') then [$multiselect$] else '' endif

    The system does not validate without else and technically we dont need an else. The ask is to have the single select copy to multi select or leave blank

    Appreciate the help.
    Thanks,
    Aayush

    ------------------------------
    Aayush Modi
    ------------------------------

    #Governance,RiskandCompliance


  • 2.  RE: Calculation Question

    Posted Thu March 03, 2022 08:39 AM
    Have you tried to check if exist then check if no null == set the value, in the same if chain

    I did not try, but in your first line, it seems that if it exist and is null, you will set it to null

    if exists([$multiselect$]) then [$multiselect$]
         elif
     ([$multiselect$]!='')
        then [$multiselect$] else '' endif


    ------------------------------
    Christophe Delauré
    ------------------------------