Simple calculation

Manoj April 16, 2019

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

1 answer

1 vote
Fabian Lim
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 14, 2022

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 17, 2022

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events