Round formula result

Ask the Community
#1

Hello Folks :slight_smile:

Do you know how to round a formula result ?

For example my formula is :

(([Data FB Ads].Filter(Day.Matches([daterangepicker 2])).[CPM (Cost per 1,000 Impressions)].Sum()-[Data FB Ads].Filter(Day.Matches([daterangepicker 4])).[CPM (Cost per 1,000 Impressions)].Sum())/[Data FB Ads].Filter(Day.Matches([daterangepicker 4])).[CPM (Cost per 1,000 Impressions)].Sum())*100

But the result is something like : XX.XXXXXXXXXX %.

I tried the Round formula but it’s not working and I didn’t find the way to round to 2 and get a result like this XX.XX %.

Do you have a solution please ?

Thank you for your help :slight_smile:

#2

Sometimes you have to add ToNumber() at the end and then round it.

There’s no way I can replicate your formula, so a screenshot or a shared doc would definitely help.

Round([My Formula].ToNumber(), 2) * 100 should work.

1 Like
#3

Hello and thank you for answer @cnr ! Oh yeah, forgot to share the link : https://coda.io/d/Copy-of-Reporting_dq8HSZSWhc4 :slight_smile:

#4

Ok, I think I fixed it

Round(
  (([Facebook Ads].Filter(Day.Matches([daterangepicker 1])).[Amout spent].Sum()-[Facebook Ads].Filter(Day.Matches([daterangepicker 4])).[Amout spent].Sum())/[Facebook Ads].Filter(Day.Matches([daterangepicker 4])).[Amout spent].Sum())*100, 
  2)
1 Like
#5

Thank you very much for your help @cnr :slight_smile:

1 Like