I have create a list (query 1) that contains some fields .in the same list (query1)I have added a new list(query 2)and then I have created a master detail and relationship.(date1=date2)
Query 1 contains : account number, name , amount etc(displayed for some filters )
Query 2 contains : Total amount for all account number without any filter .
I want to do a calculated field :amount (query 1)/total amount(query 2)(so the percent)
Is this possible ???
thank you
Query 1 contains : account number, name , amount etc(displayed for some filters )
Query 2 contains : Total amount for all account number without any filter .
I want to do a calculated field :amount (query 1)/total amount(query 2)(so the percent)
Is this possible ???
thank you