Calculated field question

[Hello1]

Hi guys, sorry for bothering but I got one question for which im trying to find a solution. If someone has an idea it would be cool.

Heres the problem im facing:

I made a table which shows race results (its bigger but i made it shorter to explain easier n faster). In the next screenshots you can see the table and the function which im using in the "EarnedPoints" field. The function works perfect but the problem is that one race gives double points, so instead of 25 points for first position it should be 50. To be more precise, i need to add in the function if the city name in the "RaceCity" field is "Abu Dabhi" to double the earned points in the "EarnedPoints" field, and all other races in other cities to keep like they are. Please if anyone knows the solution let me know


P.S. the function is much longer (till position 10) but i made it shorter to be more clear.

Thanks!

[CJ_London]

suggest multiply your iif statement (abbreviated here)

iif([EndingPosition].....)))*iif([RaceCity]="Abu Dabhi",2,1)

[June7]

Maybe:

your existing expression * IIf([RaceCity]="Abu Dhabi", 2, 1)

Note correct spelling of Abu Dhabi

[Hello1]

Damn so simple but was so far
Big thanks guys!
Solved!