Oracle Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need to add AND in IF condition

Received Response
61
Views
11
Comments
K S-92721
K S-92721 Rank 3 - Community Apprentice
in Oracle Analytics

Summary

Need to add AND in IF condition

Content

Hi Team,

I am trying to add AND in IF condition to hide few rows based on the condition but its not working for me.

The condition is <?if:CF_BALANCE!='0' and UNAPP_AMOUNT!='0'?>

It gets reflected in the tag like as follows

image

i have referred the following community answer to do it :

Kindly help me sort this issue,

Thanks,

Kishore

«1

Answers

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics & AI Coach

    Are You directly updating the form field i.e C , use field browser and add the required code and then update , sometimes if you add directly change will not reflect ,

    OR

    directly paste the code <?if:(CF_BALANCE!='0' and UNAPP_AMOUNT!='0')?>

  • K S-92721
    K S-92721 Rank 3 - Community Apprentice

    Hi,

    This condition is used in 3rd XML tag named 'C' before 'CST_LOC' XML tag

    Thanks,

  • K S-92721
    K S-92721 Rank 3 - Community Apprentice

    Hi Gayathri,

    I was not able to attach so i attached using my friend .

    Please see the previous reply for attachment

    Thanks

    Kishore

  • Saravanan V
    Saravanan V Rank 1 - Community Starter

    Hi,

    PFA,

    -Thanks,

    Kishore.S

  • K S-92721
    K S-92721 Rank 3 - Community Apprentice

    Hi Gayathri

    Thanks for the response.

    As you have said i have tried but it results in same.

    imageimage

    Thanks,

    Kishore

  • Gayathri Lakshmanan
    Gayathri Lakshmanan Rank 2 - Community Beginner

    Dont check the BI Publisher properties, what about the output?

    Also in the uploaded RTF i don't this condition anywhere

  • Gayathri Lakshmanan
    Gayathri Lakshmanan Rank 2 - Community Beginner

    Provide the RTF and the xml file for testing

  • Gayathri Lakshmanan
    Gayathri Lakshmanan Rank 2 - Community Beginner

    Try this <?if: (CF_BALANCE!='0' and UNAPP_AMOUNT!='0') ?>

    Thanks,

    Gayathri

  • K S-92721
    K S-92721 Rank 3 - Community Apprentice

    Thanks both of you for helping me out its working fine now

  • Gayathri Lakshmanan
    Gayathri Lakshmanan Rank 2 - Community Beginner

    It's working for me. Just update the condition

    <?if:(CF_BALANCE!='0' and UNAPP_AMOUNT!='0')?> using field browser and preview the output

    Don't go and check the tags