issue with data load

[Raju_6952]

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

[Digvijay_Singh]

what else you got in your table? I tried a little sample and it shows okay to me - 

[Digvijay_Singh]

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
];

[Raju_6952]

Hi @

Digvijay_Singh,

PREVIEW

The above is the full table I have been used

[Digvijay_Singh]

I don't see anything as attachment or image?

[Raju_6952]

Hi@Digvijay_Singh,

Please find the Attached screenshot for your reference.

Regards,

Raju