A virtual column in a table obtains data from another table, in form view the value is correct, but in detail view is incorrect.
When I test the formula the value is correct.
Virtual column formula:
lookup([_THISROW].[Item], โElementosTicketsโ, โIdโ, โรltimoPrecioโ)
Solved! Go to Solution.
It seems that the problem was in the origin of the data.
The column origin has the formula:
ANY(
SELECT(DetalleTickets[Precio], (and([_THISROW].[รltimoTicket] = [Ticket], [_THISROW].[Id] = [Elemento])))
)
This depends on other virtual column in the table (รltimo ticket) that had a formula that used [Related โฆ] and type ref.
I change the type to number and the formulta to:
Max(
SELECT(DetalleTickets[Ticket], [_THISROW].[Id] = [Elemento])
)
Now it works fine.
Thatโs not all thatโs different:
Looks to me like theyโre two different row with different Item column values.
The problem affect several columns, I only show one for simplicity.
I donโt understand the answer, can you explain a little more?
It seems that the problem was in the origin of the data.
The column origin has the formula:
ANY(
SELECT(DetalleTickets[Precio], (and([_THISROW].[รltimoTicket] = [Ticket], [_THISROW].[Id] = [Elemento])))
)
This depends on other virtual column in the table (รltimo ticket) that had a formula that used [Related โฆ] and type ref.
I change the type to number and the formulta to:
Max(
SELECT(DetalleTickets[Ticket], [_THISROW].[Id] = [Elemento])
)
Now it works fine.
Well done!
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |