Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a scenario where i have to find the sum of unit price for numbers of products and after that i need to find the minimum between those unit prices with respect to product category. I am trying the below formula, but result is not coming. Could anyone please help me out on this.
Min(aggr(sum([invoice.invoiced_amount]/[invoice.invoice_qty]), [product.product_category]))
Unit price - sum([invoice.invoiced_amount]/[invoice.invoice_qty])
where invoice.invoiced_amount is the amount of a particular product category and invoice_qty is quantity of that product.
The expression looks correct. How does your data model look like and which dimensions are you using in your chart?
Hi Jolly,
What if you try:
Min(aggr(sum([invoice.invoiced_amount])/ Sum([invoice.invoice_qty]), [product.product_category]))
Unit price - sum([invoice.invoiced_amount]) /Sum([invoice.invoice_qty])
Jordy
Climber