WHY Consumable device quantity shows different in list view than from view

[mihirlimje867]

Here, the quantity is showing 192 on list view:

Here, the quantity is showing 1 on the form view:

Could you please let me know why this is happening?

Thank you in advance.

[SyedMahemoH]

Hi mihirlimje867
I Hope you are doing well!

Once Checked Aggregation in List View.
Check if the Quantity field in the list view is using an aggregation function like SUM(), COUNT(), or a related function.
If aggregation is applied, the list view might be summing up quantities across multiple related records, whereas the form view is showing only the individual record's value.

If Not Try This once 
Open the list layout configuration.
Check if an aggregate function (like SUM) is applied.
If needed, change it to display the actual field value.

[mihirlimje867]

Hello @SyedMahemoH ,

Yes, I have used the aggregate COUNT function in the OnAfter transform map script.
But first, I stored the count value in a newly created variable, and then I updated the target.quantity field.

I want to list view quantity value on the form view as well.

Thank you for your response

[SK Chand Basha · Accepted solution]

Hi @mihirlimje867 

• The UI Policy "Quantity readonly until model and category qualify the asset and are not bundle" is the cause of this behaviour.

Refer this KB

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1638632

Mark it helpful and Accept Solution!! If this helps you to understand.