help with expression

[hopkinsc]

Hi, i have an application which displays promotion statistics. i have a field called DealNumbers which has several hundres dealnumbers.

I then have an expression which calculates the total sales and divides it by 3.

I only want to have this expression to populate when a specific deal is selected (900000)

Any ideas?

[hopkinsc]

Thanks everyone for your replies, i managed to get it working by using:

If (DealNumber =900000 , sum (salesQuantity)) / 3

🙂

[nathanfurby]

How does that expression work when the DealNumber does not equal 900000?

Also - what happens if other deal numbers need a factor of some kind, or what if the factor changes? Much better to manage this with data rather than in the expressions - imho

[hopkinsc]

If it does not equal 900000, it just displays -.

We are only using this application to report on a specific deal number (900000) the application can be used to look at other deals too, but no calculation will be needed.

Currently our API database does not dump out the table required to give us the result needed (but it will later on this year), so currently we would not require other deal numbers to have specific factors.

🙂