If Statement with multiple conditions

[robertsb41]

I am trying to create a calculated field based on multiple columns Contract ID, Bid Rank, and Amount.  If Bid Rank = 2 then I want Amount displayed for each row of the Contract ID.

This displays the amount but only for the row where bid rank =2, If([Bid Rank]=2, Amount).

So what I am getting is:

Contract ID	Bid Rank	Amount	Low
27	1	250	-
27	2	350	350
27	3	450	-
62	1	10	-
62	2	20	20
62	3	30	-
62	4	40	-
73	1	100	-
73	2	450	450

What I want is:

Contract ID	Bid Rank	Amount	Low
27	1	250	350
27	2	350	350
27	3	450	350
62	1	10	20
62	2	20	20
62	3	30	20
62	4	40	20
73	1	100	450
73	2	450	450

[sunny_talwar]

Try this may be

Sum(TOTAL <[Contract ID]> {<[Bid Rank] = {2}>} Amount)

[robertsb41]

Sum(TOTAL <[Contract ID]> {<[Bid Rank] = {2}>} Amount)

I get unrecognized symbol: {

[sunny_talwar]

Really? Can you try this

Sum({<[Bid Rank] = {2}>} TOTAL <[Contract ID]> Amount)

[robertsb41]

Sum({<[Bid Rank] = {2}>} TOTAL <[Contract ID]> Amount)

I get unrecognized symbol: {

[sunny_talwar]

Can you share an image of where we can see this error message?

[robertsb41]

[sunny_talwar]

What kind of object are you using this in? Is this a table in Qlik Sense?

[robertsb41]

Your expression works in a straight table but not when adding a calculated field.  Not sure how that makes sense.

[robertsb41]

Yes, just a simple table.  There are multiple rows with the same [contract id] that are ordered by [bid rank] 1-n with different [amounts].