Simple calculation

[M]

How to do simple calculation in eazybi in table. 

I have status A,B,C 

I need to do 

Status A+ Status B- Status C and remains the balance in last column.

Please guide. 

Thanks!

M

[Fabian Lim]

Hi M,

Are Status A,B,C values?

Here is some documentation: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures

Regards

[Roberts Čāčus]

Hi @M 
Suppose you wish to see the number of issues in Status A and B minus issues in Status C. In that case, I recommend defining a calculated measure in Measures. @Fabian Lim already linked the eazyBI documentation page referencing simple arithmetic functions. In your case, the calculated measure formula could look similar to the one below:

([Measures].[Issues created],[Status].[A])
+
([Measures].[Issues created],[Status].[B])
-
([Measures].[Issues created],[Status].[C])

See the eazyBI documentation page for more details on defining calculated measures - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Howtodefineanewcalculatedmember.

Best,
Roberts // support@eazybi.com