Displaying a count in a table

Markbhai — Wed, 22 May 2024 07:37:09 GMT

I have data which has Activities in one table and Assets in another table, and since an Asset can be related to mant activities and also an Activity can be related to many Assets, we have a Activity - Asset Mapping Table.

I am listing all activities in a table and am looking for a way to display which Assets are associated with the Activity.

I am satisfied with just showing a count of the Assets in a field, so I have created a Measure in the table called 'Associated Assets' and I would like this to display a number.

I am using the following but get a zero count even when the Activity has Assets.

= SUM(AGGR(COUNT(DISTINCT IF(Activity_ID = {'*'}, Asset_ID)), Asset_ID))

Thanks

Mark.

Re: Displaying a count in a table

Markbhai — Wed, 22 May 2024 07:47:22 GMT

Ignore... - It seems I was in a over complicating mood.

Adding the measure count(DISTINCT [Asset_id]) was all that was needed.

topic Displaying a count in a table in App Development

Displaying a count in a table

Re: Displaying a count in a table