How can i get the Countif Excel Function in Analyst

[Moreshwar]

I want to take the count of rows based on a data field. It is similar like the Excel Countif function. Please let me know if there is any way to do this.

Thanks
Moreshwar

[craig_karr]

I am not sure I understand how your model looks like, but would it be possible to add a new column and that couln should have a new calculation which should be IF <condition met> THEN 1 else 0

and then you could just make a summary row for the rows and then the summary row would contain the value youre looking for in the new column

[Moreshwar]

Hi Craig,

Thanks for the reply.

We used the file map to upload the data and used the @count column to get the counts.

Thanks for the immediate response.