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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.