Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Here I'm trying to calculate Total lines from a P&L table.
The below given is the structure of my P&L table.
I have tried using aggr() and sum().
Can anyone suggest me any expression to solve this issue?
Thanks in advance.
Regards,
Stan
use recNo() while loading data
then use max(recNo) to get total no of rows in table
or
add 1 as flag in load script
and use sum(flag) to get total no of rows.
Regards,