Forum

Multiple criteria a...
 
Notifications
Clear all

Multiple criteria agregation

3 Posts
2 Users
0 Reactions
68 Views
(@raman)
Posts: 33
Trusted Member
Topic starter
 

Dear all

I have a table of income statement with revenue, cogs, and other exp with sub-ledgers

I wish to calculate net profit which is revenue - cogs - other exp

I used calculate function to create separate measures for revenue, cogs and other exp

and then added those measures (revenue + cogs + other exp) to arrive net profit

Can I arrive net profit in a single measure without creation and adding of separate measures for revenue,

cogs and other exp.  Pls help.

Thanks

 
Posted : 06/09/2021 2:37 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi MJ,

Yes, just add them together in the measure e.g.:

=CALCULATE(...) - CALCULATE(...) - CALCULATE(..)

Mynda

 
Posted : 06/09/2021 7:22 pm
(@raman)
Posts: 33
Trusted Member
Topic starter
 

Thank you Mynda.  

 
Posted : 09/09/2021 3:39 am
Share: