How to multiply between two values in eazybi?

Yousuf 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.

 

Walter Buggenhout

Hi @Yousuf 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!