7 Replies Latest reply on Jun 15, 2016 11:07 PM by Rajesh L M

# need +ve profit(profit>0),-ve profit and overall profit for each subcategory(need 3 different calculative fields)

Hi Guys,

Attached is the sample store workbook with one viz which contains profit across subcategories.

I need +ve profit(profit>0),-ve profit and overall profit for each subcategory(need 3 different calculative fields)

Pls help

Regards,

Rajesh

• ###### 1. Re: need +ve profit(profit>0),-ve profit and overall profit for each subcategory(need 3 different calculative fields)

Margin = SUM( [Profit]) / SUM([Sales])-- profit margin

might help to some extent

• ###### 2. Re: need +ve profit(profit>0),-ve profit and overall profit for each subcategory(need 3 different calculative fields)

but requirement is different.

i need below columns

Subcategory,positive profit,negative profit,overall profit

ex: Books,100,-20,80

Regards,

Rajesh L M

• ###### 3. Re: need +ve profit(profit>0),-ve profit and overall profit for each subcategory(need 3 different calculative fields)

Mahfooj Khan

any suggestion here  ?

• ###### 4. Re: need +ve profit(profit>0),-ve profit and overall profit for each subcategory(need 3 different calculative fields)

Hi Rajesh!

I hope below calculations are what you are looking for.

Regards,

Sireesha

• ###### 5. Re: need +ve profit(profit>0),-ve profit and overall profit for each subcategory(need 3 different calculative fields)

Hi Sireesha,

what ever you are calculating is at high level,output is not matching

Actually if you look at sample store data,subcategory accessories have

+ve profit \$42,867

-ve profit \$-931 so overall \$41,937

Regards,

Rajesh L M

• ###### 6. Re: need +ve profit(profit>0),-ve profit and overall profit for each subcategory(need 3 different calculative fields)

Hi Rajesh!

Now, I understood your requirement correctly. In the +ve Profit & -ve Profit calculation, instead of sum([Profit]), you should write [Profit]. This will resolve your issue.

Regards,

Sireesha.

• ###### 7. Re: need +ve profit(profit>0),-ve profit and overall profit for each subcategory(need 3 different calculative fields)

Nice Srieesha, Thanks a lot