topic Multiple Conditions in an Expression in App Development

Multiple Conditions in an Expression

EvanBarrick — Thu, 14 Feb 2019 20:25:47 GMT

I have an expression that I am using in a table.

=SUM(IF(PriceScale = 'LevelA', QTY).

I want to introduce an additional piece of logic to this expression.

I have an inline table

[PriceScale, Capacity

LevelA, 1000];

My end goal is to be able to say that if 300 tickets have been sold to LevelA, there is a remaining capacity of 700.

My dimension for my table is the PriceScale.

pradosh_thakur — Thu, 14 Feb 2019 20:42:09 GMT

May be thee below.
Capacity - SUM(IF(PriceScale = 'LevelA', QTY))

EvanBarrick — Thu, 14 Feb 2019 20:50:19 GMT

My visualization is a straight Table (as below)

PriceScale QTY

LevelA 500

LevelB 300

LevelC 100

etc....

The expression works, but only for LevelA, as we are calling that out in the expression. How can we make this apply to all?

pradosh_thakur — Thu, 14 Feb 2019 21:01:20 GMT

Yes .. It's because you have specified A in the expression Capacity - SUM(IF(PriceScale = 'LevelA', QTY))

TO get for all try below

Capacity - SUM(QTY)