This content has been marked as final.
Show 6 replies

1. Re: Distinct Sums
Elie Rahi Dec 19, 2017 3:53 PM (in response to Elie Rahi)Attached is data to work with

Customer Data.xlsx 10.2 KB


2. Re: Distinct Sums
Shinichiro Murakami Dec 19, 2017 4:50 PM (in response to Elie Rahi)Hi Elie
That's the simplest calc and I don't understand where you have trouble.
Could you illustrate your problem?
Thanks,
Shin

simple_sum_SM_10.1.twbx 18.7 KB




5. Re: Distinct Sums
Elie Rahi Dec 19, 2017 7:51 PM (in response to Shinichiro Murakami)I should have been more clear with my intentions.
What I need is a calc that groups the totals into four groupings eg: Less than $100, $100$199, $200$299, More than $300 etc.
But I have done the following calc:
IF SUM([Value (DG&S)]) < 500 THEN "Less than $500"
ELSEIF SUM([Value (DG&S)]) >= 500 AND SUM([Value (DG&S)]) < 1750 THEN "$500$1,750"
ELSEIF SUM([Value (DG&S)]) >= 1750 AND SUM([Value (DG&S)]) < 3000 THEN "$1,750$3000"
ELSEIF SUM([Value (DG&S)]) >= 3000 THEN "More than $3,000"
ELSE ""
END

6. Re: Distinct Sums
Shinichiro Murakami Dec 19, 2017 8:36 PM (in response to Elie Rahi)
simple_sum_SM_10.1_v2.twbx 39.8 KB
