TDD = Test-Driven Development

Output

// 1,000 Callback
if(prop("Number") > 1000, concat(format(floor(prop("Number") / 1000)), ",", if(mod(prop("Number"), 1000) < 10, "00", if(mod(prop("Number"), 1000) < 100, "0", "")), format(mod(prop("Number"), 1000))), format(prop("Number")))

// 1,000 Callback no over 1,000,000

// -- Mod all number with 1,000,000
if(mod(prop("Number"),1000000) > 1000, concat(format(floor(mod(prop("Number"),1000000) / 1000)), ",", if(mod(mod(prop("Number"),1000000), 1000) < 10, "00", if(mod(mod(prop("Number"),1000000), 1000) < 100, "0", "")), format(mod(mod(prop("Number"),1000000), 1000))), format(mod(prop("Number"),1000000)))

// 1,000,0000 Callback

if(prop("Number") > 1000000, concat(format(floor(prop("Number") / 1000000)), ","), "")

// Final 
// -- Concat("1,000,0000 Callback ", "1,000 Callback no over 1,000,000")

concat(if(prop("Number") > 1000000, concat(format(floor(prop("Number") / 1000000)), ","), ""), if(mod(prop("Number"),1000000) > 1000, concat(format(floor(mod(prop("Number"),1000000) / 1000)), ",", if(mod(mod(prop("Number"),1000000), 1000) < 10, "00", if(mod(mod(prop("Number"),1000000), 1000) < 100, "0", "")), format(mod(mod(prop("Number"),1000000), 1000))), format(mod(prop("Number"),1000000))))

// Round number

concat(if(round(prop("Number")) > 1000000, concat(format(floor(round(prop("Number")) / 1000000)), ","), ""), if(mod(round(prop("Number")),1000000) > 1000, concat(format(floor(mod(round(prop("Number")),1000000) / 1000)), ",", if(mod(mod(round(prop("Number")),1000000), 1000) < 10, "00", if(mod(mod(round(prop("Number")),1000000), 1000) < 100, "0", "")), format(mod(mod(round(prop("Number")),1000000), 1000))), format(mod(round(prop("Number")),1000000))))

// If empty

if(empty(prop("Number")), "", concat(if(round(prop("Number")) > 1000000, concat(format(floor(round(prop("Number")) / 1000000)), ","), ""), if(mod(round(prop("Number")), 1000000) > 1000, concat(format(floor(mod(round(prop("Number")), 1000000) / 1000)), ",", if(mod(mod(round(prop("Number")), 1000000), 1000) < 10, "00", if(mod(mod(round(prop("Number")), 1000000), 1000) < 100, "0", "")), format(mod(mod(round(prop("Number")), 1000000), 1000))), format(mod(round(prop("Number")), 1000000)))))

Tester

if(prop("Output") == prop("Expected"), "✅ PASS", "❌ FAILED")

Comma Thousand

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/ec42d592-d1ae-4fd5-9265-2e5baa4940e6/Screen_Shot_2564-06-25_at_21.25.09.png

สวัสดีครับ วันนี้ผมมาแชร์เทคนิคการเขียน สูตรแบบ ยังไงก็ไม่พลาดแน่ๆ กันครับ

.

เทคนิคที่ใช้ TDD (Test-Driven Development) คือ โดยผมประยุกต์ใช้ใน Notion

  1. การสร้าง Table มา
  2. กำหนด Column