Oracle Analytics Publisher

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

How to use if statement for comparing dates in BIP template

Question
2
Views
0
Comments
Chez
Chez Rank 4 - Community Specialist

Summary:

How to use if statement for comparing dates in BIP template

Content (please ensure you mask any confidential information):

I have customised the Customer Statement Data Model to show me the apply_date of the payment. Now I wish to show payments only where the apply_date is before the statement_date. I have put in the following conditions to try and achieve this.

<?if:CDC_PAYMENT_AMT=''?>0<?end if?>

<?if:CDC_PAYMENT_AMT!='' and CDC_APPLY_DATE <= STATEMENT_DATE?><?CDC_PAYMENT_AMT?><?end if?>

<?if:CDC_PAYMENT_AMT!='' and CDC_APPLY_DATE > STATEMENT_DATE?>0<?end if?>

All my payment amount are however presenting as null values which is incorrect. There are payments that should appear and some should appear as 0
I have uploaded the rtf and here is snippets of the xml where you can see the statement_date and also the cdc_apply_Date.

So in this particular example the apply date is before statement date therefore the payment_amount should pull through as 4664.40 but it is pulling as null value

Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):