r/Notion•
headsniper

Numbers not showing in my formula...

Formula

I have a number coming from a rollup that is being used to determine a product price for another database.

I've been doing some research and all I've seen is that Rollups are considered strings, but I'm not sure how to convert it to numbers. using the toNumber doesn't seem to do the trick.

if(prop("Order Price") == "N/A", "N/A", prop("Order Price") * prop("Count"))

This is my formula, it shoots out "N/A" easy peasy, but no numbers are pulling from the Order Price rollup.

I don't have any major experience to coding, and when I saw those prop fields, I knew instantly I wouldn't get how to make this formula. Can I get some help with this?

Posted Nov 2, 2023, 1:29 AM UTC

13
Loading comments…