
1. Re: LOD Calculation
Anisha Jhamb May 4, 2018 2:34 PM (in response to Richa Girdhar)Can you attach a workbook with sample data?

2. Re: LOD Calculation
Deepak Rai May 4, 2018 2:53 PM (in response to Richa Girdhar)bucket 5 total is 45 and 33,12 for 7 and 8. logic please?/?

3. Re: LOD Calculation
Richa Girdhar May 4, 2018 2:59 PM (in response to Deepak Rai)Hey Deepak,
I'm adding values that 'true' or 'true and false'. I'm not using the values it if it's just false.


5. Re: LOD Calculation
Richa Girdhar May 4, 2018 3:10 PM (in response to Deepak Rai)Hey Deepak,
There are 2 headers, true and false.
If the value lies in both true and false I'm adding it. For example if you look at Bucket 6, the true is 16 and false is 2, so the sum is 18.
Bucket 4 has only true values, But I'm also using only true values, so the sum is 43.
For Bucket 7, there is no true  only false, so the sum is 0 because I'm not adding any only false values.
I hope this explanation was more helpful.

6. Re: LOD Calculation
Anisha Jhamb May 4, 2018 3:14 PM (in response to Richa Girdhar)But Buckets 7 Total is 33

7. Re: LOD Calculation
Deepak Rai May 4, 2018 3:17 PM (in response to Anisha Jhamb)Anisha,
Do u see the same as I see??.
Deepak
Richa,
why 7 and 8 are 33 and 12

8. Re: LOD Calculation
Richa Girdhar May 4, 2018 3:17 PM (in response to Anisha Jhamb)Oh I get it now, my bad. The total for Bucket 7 and 8 should be 0.

9. Re: LOD Calculation
Richa Girdhar May 4, 2018 3:22 PM (in response to Deepak Rai)Deepak, total for Bucket 7 and 8 should be 0. The ones that are red don't need to be included in my final calculation. I color coded them but forgot to recheck the final number. My bad.

10. Re: LOD Calculation
Deepak Rai May 4, 2018 3:24 PM (in response to Richa Girdhar)1 of 1 people found this helpful{FIXED Description:SUM(TRUE)+SUM(IF TRUE<>0 THEN FALSE END)}
Try this

11. Re: LOD Calculation
David Maning May 4, 2018 3:55 PM (in response to Richa Girdhar)Hi Richa,
The solution is following:
1) Create calculated field that mark the required rows for further summing:
IF { FIXED [State]:SUM([Profit])}>10000
THEN 'summed'
END
2) Summing of required rows:
{ FIXED :SUM(
IF [Sum checking]='summed'
THEN [Profit]
END)}
Please find an example attached. The logic is clear so you can amend and apply it based on your needs.
Please mark my response as correct and helpful.
Trust this helps.
D

4Richa.twbx 1.2 MB


