
1. Re: Multiple Conditions
Jaime Lego Jun 6, 2018 1:36 PM (in response to Jane Abc)Have you tried creating two fixed calculations for total category and total supplier and then referencing those in your IF calculation?
[Total Category Order Amount]
{ FIXED [Category]:sum([Order Amount])}
[Total Supplier Order Amount]
{ FIXED [Supplier]:sum([Order Amount])}
IF [Total Category Order Amount]>1000
AND [Total Supplier Order Amount]<1000
THEN [Order Amount]
ELSE 0
END

2. Re: Multiple Conditions
Joe Oppelt Jun 6, 2018 1:37 PM (in response to Jane Abc)Two LOD calcs:
{ FIXED [Category] : SUM( if [PO Order Amount] > 1000 then 1 else 0 END ) }
{ FIXED [[supplier] : SUM( if [PO Orderr amount] < 1000 then 1 else 0 END ) }
For each row, if both calcs are 1 then you have a row you want to use.
If you can't get this to work, upload a sample workbook.

3. Re: Multiple Conditions
Deepak Rai Jun 6, 2018 1:43 PM (in response to Jane Abc)You have a,b,c in this data because one of the supplier for a is less than 1000. Pl check screenshot and attached.
Thanks
Deepak

Multiples.twbx 15.7 KB


4. Re: Multiple Conditions
Jane Abc Jun 11, 2018 12:30 PM (in response to Deepak Rai)Hi Deepak,
Appreciate your response; however, i am still getting errors.
In your suggestion above,I don't want to include category "a" since zxy company has more than $1000 so Category a's supplier is more than 1000.
I want to just see categories more than $1000(total) with condition each supplier in that category not to exceed $1000. So, in my example above i just want to see category "b" and "e".
Is there a way to sum up total suppliers for one category? e.g. sum of the total suppliers value for category "a"?
Thanks a lot

5. Re: Multiple Conditions
Jane Abc Jun 11, 2018 12:39 PM (in response to Jaime Lego)Hi Jaime,
Appreciate your response; however, i am still getting errors.
I tried to apply your formula but it is still not working
I want to just see categories more than $1000(total) with condition each supplier in that category not to exceed $1000. So, in my example above i just want to see category "b" and "e".
Is there a way to sum up total suppliers for one category? e.g. sum of the total suppliers value for category "a"?
Thanks a lot,
Jane

6. Re: Multiple Conditions
Deepak Rai Jun 11, 2018 1:10 PM (in response to Jane Abc)Here it is, Just Changed the Calculation to give u what u r looking for.
Thanks
Deepak
If it Helps, Pl mark it Helpful and CORRECT to Close Thread

Multiples.twbx 14.3 KB


7. Re: Multiple Conditions
Deepak Rai Jun 21, 2018 1:37 PM (in response to Jane Abc)1 of 1 people found this helpfulHi Jane,
If it Helped You, Can you Please Close This Old Thread To Help Someone looking for same answer by marking my Reply as CORRECt. The CORRECT Button is under my Reply in your this main Thread, Not in email
Thanks
Deepak

8. Re: Multiple Conditions
Jane Abc Jun 21, 2018 1:37 PM (in response to Deepak Rai)This is great! Thanks a lot! Much appreciate your help!
