Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

This Calculation is broken

Received Response
31
Views
4
Comments
Stefano_Mazzocca
Stefano_Mazzocca Rank 6 - Analytics Lead
in Oracle Fusion Data Intelligence

I imported this Excel with 2 checks names:

image.png

It gives me 2 lines:

image.png

For line 1 (i.e. check 1) I want to check how many persons have birth date less than 1940.

For line 2 (i.e. check 2) I want to check how many persons have blank flexfield.

So my calculation is the following:

image.png

So why the result is spreaded across all rows?

image.png

I expected some number for row 1 and a different number for row 2 (and not, it's not a coincidence, it is summing everything repeating the same value for all lines)

Tagged:

Answers

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    Hi @Stefano_Mazzocca,

    I see you have not received a response on this query and there is probably not enough information to give you a specific response. Did you intend to ask this question in the FDI forum or is it a general OAC question?

    To troubleshoot, start by removing the 'Codice controllo' column and change the format of your Date column so it includes time (more detail). Also, test your two case statements separately.

    Regards,

    John

  • Stefano_Mazzocca
    Stefano_Mazzocca Rank 6 - Analytics Lead

    Hi @JohnW-Oracle , this is a FDI question so it should be the right place.

    Also I'm not sure about your suggestion. The columns are exactly how they should be.

    Thank you

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    Hi @Stefano_Mazzocca,

    In general terms, the idea is to simplify the report as much as possible to see if the data changes and make it easier to troubleshoot. You may want to log a SR for this question and include a DVA export.

    Regards,

    John

  • Bret Grinslade - Oracle Analytics-Oracle
    Bret Grinslade - Oracle Analytics-Oracle Mod

    For trouble shooting… a good place to start is make a calculation for each state and list the detail. Once you feel the calc is working as expected — you can add the sum on top. So start with three calcs and put them on the same chart to see the low-level grain.