Hey sup! making like a price list, i wanna make like two fields/blocks, one of them should be how much £ with the ones with the status column marked as Yes. The other should b the £'s added up for the ones marked as No. how'd i do this?
An easy way is to create two new properties using Notion formulas to have the sums separately.
New property Yes
if(prop("Purchase") == "Yes", prop("Price"), 0)
New Property No
if(prop("Purchase") == "No", prop("Price"), 0)
Then at the bottom of both new columns you can select "Sum" in the Calculate options. Also you can rollup that information into other databases if needed.
Hope that helps.