Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Yes, Saresh. I am using the same version. Is there any solution to this? - Zimmer
-
Thanks, Sven-BIP. That explained what I was wondering about.
-
Thanks, Sven-BIP. Editing the query in the data model helped solve my problem.
-
Thanks Sven-BIP. I used NVL but for some reason it's not working. I am unable to figure out why. Here's my code: <?xdofx: nvl(AMOUNT1,0)?><?format-number(AMOUNT1,'## ##0',’Yen’)?>,-
-
I think its because I am trying to format number afterwards but I don't know how to nest these two tags.
-
Thanks, Venkat-BIP. Actually I am summing some variables at the end like sum(AMOUNT1+AMOUNT2+AMOUNT3) which is the reason why I want to assign a default value to these as summing variables if they are null lead to error. This idea of setting default value in the data models is great but I am trying to put it in code.…
-
Thanks, Venkat-BIP. But I am wondering if this <?param@begin...?> works with a parameter already present in a data model too. I don't want to declare a new parameter. Regards,
-
Thanks a lot, Youssef. Using <?choose?> worked. Since MY_VARIABLE is defined beforehand in my data model, how can I set default value for it? For instance: <?otherwise:?><?MY_VARIABLE=3?><?end otherwise?> something like that? Regards,
-
It's a number. A double. It's from a data model created as a result of a query.
-
Thanks for your help, Venkat-BIP. I changed my code a little in order to format numbers. <?if:MY_VARIABLE!= '*'?><?format-number(MY_VARIABLE,'## ##0',’Yen’)?>,-<?end if?> <?if:MY_VARIABLE='*'?><?format-number(5,'## ##0',’Yen’)?>,-<?end if?> Here I have '*' as I am using 11g and I am trying to set 5 as default value. But I…