Oracle Analytics and AI

2804878

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

asim cholas

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