Oracle Analytics Cloud and Server

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

Multiple If Conditions in One Row RTF Template

Accepted answer
2116
Views
1
Comments

Summary

Multiple If Conditions in One Row RTF Template

Content

Hi Guru's,

I have a quick question on creating a RTF template and was wondering if anyone has had the experience of the similar issue in the past.

I have a RTF Template with  6 columns , Where I want to put a condition that If Category is Payment show me the value and this should only work will column4. For column 5 and 6, I want to put a condition that if the category is not Payment, show me the value.

 

Employee No.

Employee Name

Date

NAT. INS. No.

 

 

   

 

Payments

Hours/Units

Rate

Amount

Deductions

Amount

Start Condition --- If category is Payment show me the value1

Value2

Value3

Value4

End Condition

Start Condition --- If category is Deduction show me the value1

Value4

End Condition

 

rtf_issue.JPG

Best Answer

  • Ron-92886
    Ron-92886 Rank 3 - Community Apprentice
    Answer ✓

    <?if: start_condition ='Payment'?>Value 1, Value 2 etc<? end if?>

    <?if: start_condition!='Payment'?>Value<?end if?>