How to multiply between two values in eazybi?

[Yousif Al Rawahi]

How to multiply between 'Laptops and Tabs Price' (which displays the price of each model) and 'Objects created' (which displays number of each model created) in eazybi?

What I want is the total price of each model based on how many objects created.

And as you can see, in 'HP ProBook 450 G6' (and other models), it shows two different prices, is there a way to display separately? 

FYI: 'Laptops and Tabs Price' selected from the Dimensions, and 'Objects created' selected from Measures.

[Roberts Čāčus]

Hi @Yousif Al Rawahi

The value of Laptops and Tabs price is numeric. I recommend importing it as a measure. After that, you can use the "Laptops and Tabs price sum" measure to view the total from all applicable Assets objects. See an example below, where I have the "Rate" attribute from "Person" type objects imported as a dimension and measure:

With the measure "Person Rate sum" there is no need to define additional calculations. Please visit the eazyBI documentation page for more details on how numeric attributes are imported in Measures - https://docs.eazybi.com/eazybi/data-import/data-from-jira/assets#Assets-Measures.

Best,

Roberts // support@eazybi.com

[Yousif Al Rawahi]

In Jira Assets, I have a list of all models of laptops in one table as shown below. Total 407 laptops with different models.

In eazybi, I grouped the laptops by models by importing as Dimensions, and dragged to Rows, and selected 'Object Laptops and Tabs Price' as Measures, but it doesn't display any value. I believe this is due to price will display of each model only, not the grouped ones, right?

Is there a way to display to solve this?

[Roberts Čāčus]

Hi @Yousif Al Rawahi 

"Object Laptops and Tabs Price" is a property for individual Object dimension members. To see the value of this property, you would need each laptop and tablet type object member in the rows.

Please see if you can select the "Price" attribute for import as a measure in the eazyBI import options. Or see in Measures whether it is already imported as a measure "Laptops and Tabs Price sum".

Best,
Roberts // support@eazybi.com

[Walter Buggenhout]

Hi @Yousif Al Rawahi,

This would be a fairly simple calculation. In the Measures section of your report (sitting right above the area you included in your screenshot), either select the User defined or Report specific section and add a new calculated measure.

Name it Total Amount (or anything that makes it clear for you what it means) and add the following formula:

[measures].[Laptops and Tabs Price] * [Objects created]

I notice from your screenshot that you seem to have imported the price as a dimension. That is probably because you have set up your data in Jira in such a way that this is coming from a select custom field, but that feels a bit odd for information you would like to use in calculations. If you imported the price value as a property, you could also try to solve the calculation like this:

[Laptops and Tabs Price].currentMember.Get('Laptops and Tabs Price') * [Objects created]

As the name of the property (the part in parentheses behing .Get()), make sure to use the name of the custom field you are importing here.

Hope this helps!

[Yousif Al Rawahi]

I have used this calculation: [Laptops and Tabs Price].currentMember.Get('Laptops and Tabs Price') * [Objects created], but it says (Formula is not valid:
MDX object '[Objects created]' not found in cube 'Assets'). So I [Measure] before [Objects created], it shows no error but it doesn't display any value.

Have I missed something?