topic Re: Help with Alternate States Expression in App Development

Help with Alternate States Expression

dana — Wed, 22 Dec 2021 16:26:04 GMT

Hi,

The following expression doesn't work:

sum({Grp1}ItemSalesPrice * Quantity)

it works fine without the alternate state group.

Any idea why?

Thanks!

agigliotti — Mon, 01 Jun 2020 14:38:53 GMT

what do you mean?
your expression looks fine.
are you sure that your alternate state name match with "Grp1" ?
what is your expected result?

dana — Mon, 01 Jun 2020 15:32:13 GMT

Hi,

Yes, the name is correct.

the calculation ( of total price) is fine without the alternate state.

Thanks..

agigliotti — Mon, 01 Jun 2020 15:48:38 GMT

could you share a sample app woth mock data to look at?
i don't understand why you are using alternate state in that expression.

dana — Mon, 01 Jun 2020 18:41:44 GMT

Hi,

There are actually two expressions for each state for comparison in a table.

I will try to recreate the issue in order to check whether there is an issue with the price field.
thanks for your kind help!

rwunderlich — Mon, 01 Jun 2020 20:54:07 GMT

"The following expression doesn't work:"

It would be useful if you told us what result you are getting -- eg null, zero, a number different than without the State.

-Rob

dana — Tue, 02 Jun 2020 05:17:38 GMT

Hi,

The expression works fine. It turned out that the field didn't have values for periods I selected.

Thanks for your trying to help!