Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

I have two small doubts about RCOUNT(1) and Convert Amount into words

Received Response
1
Views
1
Comments
2804878
2804878 Rank 1 - Community Starter
edited Aug 13, 2024 6:07PM in Oracle Analytics Cloud and Server

Hi, This is R K.

Related to ROWCOUNT:

I have a small doubts about RCOUNT(1) when i use it i'm getting Serial Number which is fine until I use Grand Total when I use both its showing both total of RCOUNT(1) and my SUM(Amount) how can i disable the Total of RCOUNT(1) without disabling the Grand Total.

Convert Amount into words:

I tried to use some conversions in the database level but in the Aggregation level after getting total I cant able to convert the Grand Total into Amount.

can anyone Please Help he out.

Thanks in Advance.

Regards

R K

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics & AI Lead

    Dear R K

    For the first issue, Simply set aggregation rule to None in Criteria Fx.

    Second issue can you elaborate with an example .. Confused.

    Thanks

    Aj