formula case when type is bill then amount
# ask-stanley-ai
n
formula case when type is bill then amount
c
AI generated answer (using internal Slack threads):
Based on the conversations, it seems like you are trying to create a formula that will return the amount when the type is 'Bill'. You can use a CASE statement in your formula to achieve this. Here is an example of how you can structure your formula:
Copy code
CASE WHEN {type}='Bill' THEN {amount} ELSE 0 END
This formula will check if the type is 'Bill', if it is, it will return the amount, otherwise, it will return 0. Please note that the field names used in the formula should match exactly with the field names in your NetSuite environment. Also, the formula type should be set appropriately based on the data type of the fields used in the formula. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.827962816
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.82318604
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.817629278
Please provide your feedback on this answer.