topic Re: Using Measure Variables in calculated expressions in App Development

Using Measure Variables in calculated expressions

Anonymous — Sat, 16 Nov 2024 08:43:07 GMT

Hi, I created some measure variables and want to complete some calculations.

The two in this example are mocccupancyexp_june & mdirectsalesjune.

At first I tried just dividing them (column 1), but realized it was incorrect. Columns 2 & 3 are the correct value & column 4 is a division of the two for the right percentage.

I was using =$(moccupancyexp_june) / $(mdirectsalesjune) for the initial calculation, but I must have made a mistake. The image below has my calculations in the column header. Thanks for any help

Re: Using Measure Variables in calculated expressions

Gysbert_Wassenaar — Sat, 10 Feb 2018 13:06:11 GMT

Well, suppose mocccupancyexp_june is sum(DirectSales)+1 and mdirectsalesjune is sum(Amount). Then $(moccupancyexp_june) / $(mdirectsalesjune) would become sum(DirectSales)+1/sum(Amount). And that's completely different from (sum(DirectSales)+1) / sum(Amount). Just an example of what could go wrong. Since I don't know what expressions your variables really contain there's no telling what really is going wrong.

Re: Using Measure Variables in calculated expressions

Anonymous — Sat, 10 Feb 2018 16:23:40 GMT

I was missing a set of (). Thanks!