Hi,
Is there a way to validate search formulas?
...
# generalm
Marwan
12/14/2022, 2:33 PMHi,
Is there a way to validate search formulas?
I have this one
Copy code
CASE WHEN FLOOR({custcol_ed_total_discount})={custcol_ed_total_discount} THEN TO_CHAR({custcol_ed_total_discount}) ELSE CONCAT(TO_CHAR(ROUND({custcol_ed_total_discount}, 2)), '000') ENDs
Shawn Talbert
12/14/2022, 4:08 PMavoid complicated search formulas.
🧐 1
Shawn Talbert
12/14/2022, 4:35 PMseriously. They are difficult to debug, as Marwan is finding out.
m
Marwan
12/14/2022, 4:46 PMI have too. The data will be imported into another system, that has a lot of requirements on how the data should look like.
s
Shawn Talbert
12/14/2022, 5:33 PMPerhaps consider a script to post-process the data prior to it being made available to the other system? On a broader level, perhaps considering a dedicated analytics tool (e.g. outside netsuite)?
m
Marwan
12/15/2022, 4:31 AMI guess we will have to process the data first yeah.
k
Karina
12/15/2022, 3:45 PMplop it into Analytics, it will tell you what’s wrong
5 Views