I need a help or advice. In pictures below y...

(Šumar BP) #1

I need a help or advice.

In pictures below you can see that two sheets are ref. My question is: is it possible that the last offered choice

(in this case number 4), select by itself, because there is always only one choice?

(Aleksi Alkio) #2

Something like this for the initial value field… ANY(SELECT(TableName[Column],AND([GROUP]=[_THISROW].[GROUP],[VALUE]=[_THISROW].[VALUE])))

(Dinh Nguyen Nguyen) #3

Have you tried using the column’s Initial Value expression?

(Šumar BP) #4

Jes I have but

this

column have more than one choice.

Aleksi Alkio a will try that formula. Tkanks!

(Šumar BP) #5

I can not figure out how to write a formula. In coment below I attach pictures of tables. If someone can help me I will be grateful.

This is the first table where I need that column “bonitet” chose value for itself.

(Šumar BP) #6

This is second table where is the value of column “bonitet”

(Aleksi Alkio) #7

ANY(SELECT(TableName[BONITET],AND([ODSJEK]=[_THISROW].[ODSJEK1],[VRSTA]=[_THISROW].[VRSTA]))) Translate

(Šumar BP) #8

Thank you very much. This formula works.

(Aleksi Alkio) #9

You’re welcome