Best way to round up or down a % figure after divide calculation

[HarryB]

Hi,

I am calculation a conversion from MRL to MQL and from MRL to SAL.

I would like to round up or down the % figures. What would be the best way to do that.

This is my code. Would using the round function help? 

How would I add this in to my code.

Lead Conversion MRL to MQL = DIVIDE('Lead'[Lead MRL count],'Lead'[Lead MQL count])

[Greg_Deckler]

@HarryB Try:

Lead Conversion MRL to MQL = ROUND(DIVIDE('Lead'[Lead MRL count],'Lead'[Lead MQL count]),5)

[HarryB]

HI @Greg_Deckler ,

Thank you for your response.

I tried your solution but there was no change at all to the figures.

Would you be able to suggest something else which might help.

Kind regards,

HarryB

[HarryB]

@Greg_Deckler 

This is what I would like to see.

Sum of Lead Conversions MRL to MQL

74%

35%

13%

60%

Does that help?

[Greg_Deckler]

@HarryB What results are you expecting?