Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone ,
I have the samll req like below and do the calculation in design itself for further process.
The dimensions I have is
Account no,custid,aod,period,balance and the logic for the count is count (distinct accountno)
When am writing the below script in our straight table its showing the correct result when am checking the expression total (But idlely that’s not fill my req and attached the sample data here) but when am checking the sum showing different count.
Thanks in adv,
Dhanu
Don't understand what is your actual problem and requirement.
Can you explain specifically?
Please use cross table to get required output in script
Like this ?
Not working Manish...I have to show like below.
Account No | Custid | AOD | period | Balance | Logic(count of distinct Account No) |
285692465 | 10999 | 02/25/13 | 02/28/13 | 900000(Recent Balance) | 1 |
2856924 | 104649 | 04/26/13 | 04/30/13 | 47474(Recent Balance) | 1 |
Thanks,
Dhanu