Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to use Rowno(total) along with If(Count(distinct IncidentID) >49, Count(distinct IncidentID),0) in a stright tabke but its not working as shown below, but without Rowno(Total) its working.
Second Case with Rowno(Total)
any suggestions will be highly appreciated.
Kind Regards,
Raju
what else you got in your table? I tried a little sample and it shows okay to me -
Load * inline [
Product,Incident ID
A,49
A,100
B,35
B,23
A,234
B,1000
A,45
B,98
A,90
B,120
];
I don't see anything as attachment or image?