Stock.Level returns the total quantity of stock on hand, while Stock.Value returns the total value of stock on hand.

## Stock.Level

### Syntax

= Pinboard("stock.level", "Required Information",Location)

Keyword | Description |

sum | Simple total of all products. If you have 3x "A" and -1 "B" in stock the value returned will be "2" |

sum.positive | Simple total of all products with positive stock levels. If you have 3x "A" and -1 "B" in stock the value returned will be "3" |

sum.negative | Simple total of all products negative stock levels. If you have 3x "A" and -1 "B" in stock the value returned will be "-1" |

count | Simple count of products with any stock levels. This is the number of product lines NOT the actual amount of stock. If you have 301x "A" and -1 "B", and 16 "C" in stock the value returned will be "3" |

count.positive | Simple count of products with stock positive levels. This is the number of product lines NOT the actual amount of stock. If you have 301x "A" and -1 "B", and 16 "C" in stock the value returned will be "2" |

count.negative | Simple count of products with stock levels. This is the number of product lines NOT the actual amount of stock. If you have 301x "A" and -1 "B", and 16 "C" in stock the value returned will be "-1" |

Caution. When calculating the results for all stores the value of "sum.positive" +/- "sum.negative" may not equal "sum". This happens when one store has "2" and another has "-2". This also applies to the other values such as "count"

If using variant based inventory, such as tracking different issues of magazines and periodicals, the "count" statistics will group all the variants together and only report one figure for a single product

### Example

=Pinboard("stock.level", "sum.positive",32)

Return the total number of items in stock for store #32

## Stock.Value

### Syntax

= Pinboard("stock.value", "Required Information",Location)

Keyword | Description |

sum | Simple total value of all products. |

sum.positive | Simple total value of all products with positive stock levels. |

sum.negative | Simple total value of all products negative stock levels |

Caution. stock.value pinboard can be show small rounding differences especially if you have variable weight items.

Example Spreadsheet (Requires correctly installed Excel Addin)