Forum Discussion

John_V12's avatar
John_V12
Frequent Visitor
4 years ago
Solved

Divide two columns

Hi all, I could not find the right formula for the below, can someone please assist:   I have two columns in one dataset, the one column is sales and the other is product quantity. The sales co...
Need Help
  • John_V12's avatar
    John_V12
    4 years ago

    Hi all,
    I solved the incorrect totals by creating a calculated column and not a measure.
    Thanks!

littlemojopuppy's avatar
littlemojopuppy
Community Champion
4 years ago

Hi John_V12 

Try this...

DIVIDE(
	[SalesValue],
	[Quantity],
	BLANK()
)

DIVIDE() function will substitute BLANK() for any row where it cannot perform division (Quantity = 0 or is missing a value).

 

Hope this helps!