By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!
  • Guest, before posting your code please take these rules into consideration:
    • It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
    • You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
    • Don't share a wall of code. All we want is the problem area, the code related to your issue.

    To learn more about how to use our BBCode feature, please click here.

    Thank you, Code Forum.

Help with Oracle Data Visualization Expressions


New Coder
Hi, im really new to coding world and struggling with below problem which im sure has an easy fix. Im working on a project in Oracle Data Visualization tool and using set of expressions based on SQL to make queries and calculation. The problem is i need to write a function to identify the week a variable reaches 50 and then not count it afterwards. For example if variable A reaches 50 in week 1, i need to count it as 1, but it should not be counted in week 2 as it reached 50 in week 1. I wrote a code to show if variable A >= 50 then return the week. But this will include A in week 2 as well because it’ll be still greater than 50 in week 2. So what is the logic or how do i exclude the variables that already reached 50 in previous weeks? Appreciate your help in this. Thanks a lot!

New Threads

Buy us a coffee!

Top Bottom