topic Re: Working with variables in App Development

Working with variables

jerryr125 — Tue, 28 Sep 2021 12:46:38 GMT

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

Re: Working with variables

PrashantSangle — Tue, 28 Sep 2021 12:57:55 GMT

use that specific product in set analysis

vMaterialVariance

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

Regards,

Prashant Sangle

Re: Working with variables

jerryr125 — Tue, 28 Sep 2021 13:35:23 GMT

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

Re: Working with variables

jerryr125 — Tue, 28 Sep 2021 13:43:47 GMT

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