Working with variables

[jerryr125]

Hi - I have a question about variables.

I have the following variables set up:

vMaterialC2021

Sum({$<[MaterialCDateYear]={'2021'}>} (MaterialCPrice))

vMaterialC2020

Sum({$<[MaterialCDateYear]={'2020'}>} (MaterialCPrice))

Both variables work - no issues.

I am trying to calculate the variance between vMaterialC2021 and VMaterialC2020.

vMaterialVariance

=sum({<[MaterialCDateYear]={'2021'}>} (MaterialCPrice))-sum({<[MaterialCYear]={'2020'}>} (MaterialCPrice))

The formula calculates it for the entire population not just for the specific material number.

I also tried:

=sum(vMaterialC2021-vMaterialC2020)

no luck

Any thoughts ? Jerry

[PrashantSangle]

use that specific product in set analysis

like

vMaterialVariance

=sum({<[MaterialCDateYear]={'2021'},product={'Product_name'}>} (MaterialCPrice))-sum({<[MaterialCYear]={'2020'},product={'Product_name'}>} (MaterialCPrice))

Regards,

Prashant Sangle

[jerryr125]

Hi - thank you for the response.

I am using the variable in a table visualization so therefore setting the product_name will not work.

Each product has its own calculation.

Thoughts ? Jerry

[jerryr125 · Accepted solution]

Hi I created a master measure -got it -thanks - Jerry