Forum Discussion
Problem with division
One possible issue could be that the COUNT function is counting duplicate values in either the PEDIDO_VENDA or NF_SAIDA table. To fix this, you can try using the DISTINCTCOUNT function instead of COUNT. This will only count unique values in the table.
Another possible issue could be that the PEDIDO_VENDA and NF_SAIDA tables have different filters applied, resulting in a different count for each table. To fix this, you can try applying the same filters to both tables before performing the division.
Lastly, you can check for any hidden filters that may be affecting the data.
Try the following:
% de conversão em vendas = DIVIDE(DISTINCTCOUNT(NF_SAIDA[NS_CODIGO]), DISTINCTCOUNT(PEDIDO_VENDA[NS_CODIGO]))
If the above still does not work, please provide more details about your data and the filters applied to the tables.
One possible issue could be that the COUNT function is counting duplicate values in either the PEDIDO_VENDA or NF_SAIDA table. To fix this, you can try using the DISTINCTCOUNT function instead of COUNT. This will only count unique values in the table.
Another possible issue could be that the PEDIDO_VENDA and NF_SAIDA tables have different filters applied, resulting in a different count for each table. To fix this, you can try applying the same filters to both tables before performing the division.
Lastly, you can check for any hidden filters that may be affecting the data.
Try the following:
% de conversão em vendas = DIVIDE(DISTINCTCOUNT(NF_SAIDA[NS_CODIGO]), DISTINCTCOUNT(PEDIDO_VENDA[NS_CODIGO]))
If the above still does not work, please provide more details about your data and the filters applied to the tables.