calculating a value based on other column

[TechR21]

I have the following data

a ticketnumber has an id in the ticketdetails table. This id is linked with the table tickets. A ticket has a majorticketid, or is blank (when there is no major ticket assigned).

When there is a majorticket assigned, this also has a ticketnumber in the table ticketdetails.

Now i need to be able to create a column ticketdetails table, that basically says;

when ticket.majorticketid is not empty then ticketdetailsticketnumber, otherwise blank

both tables are linked via ticketid, one on one relationship.

[amitchandak]

@TechR21 , A new column in ticketdetails

related(ticket[majorticketid])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[TechR21]

I dont need the majorticketid, I need the ticketdetailsticketnumber when majorticketid is not empty

[amitchandak]

@TechR21 , In the tickets table , assuming both are joined

maxx(relatedtable(ticketdetails),[ticketdetailsticketnumber])

else add filter

maxx(filter(ticketdetails,ticketdetails[ticket id] = tickets[ticket id]) , ticketdetails[ticketdetailsticketnumber])