I have a transaction saved search. Criteria I have...
# generalk
Koon Kabob
02/15/2024, 10:00 PMI have a transaction saved search. Criteria I have the dates within Jan 1 - June 30 and Main line True. Results tab as follow:
Customer Name COUNT. Results give me 216
Amount (Net) SUM. Results give me $618,374.19
Formula (Currency) SUM. Results give me 1602.78 which is wrong.
My formula is Sum({netamount})/Count({name})
I just need the total amount / total customer count. 618374.19/216= 2862.84
I believe it's giving me the 1602.78 because it's taking into a COUNT of customers including their Sales Orders which is 386.
Anyone know how to do this?
i
Israel Gonzalez
02/15/2024, 10:05 PMFormula (Currency) SUM seems wrong, since you are already dividing the sums. Try MAX
k
Koon Kabob
02/15/2024, 10:06 PMIt gives me the same result :(
m
MGBC
02/15/2024, 10:07 PMTry COUNT(DISTINCT({name}))
k
Koon Kabob
02/15/2024, 10:09 PMBeautiful! This worked! Thank you so much!! ☺️☺️☺️
Koon Kabob
02/15/2024, 10:09 PMSide question, how or where can I go to learn these things? The different codes/functions!
m
MGBC
02/15/2024, 10:13 PMSearch “sql expressions” in suiteanswers
❤️ 1
MGBC
02/15/2024, 10:13 PMThat’s a good start