Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For the growing accounts column i have the expression as =fabs(Column(8)='Growing') and for the total mode i set it to sum of rows
how am i suppose to retrieve 328 and set it into a variable
Nvm thanks for the help bro i got it by using the macro
Sub Get_Growing_Accounts
Application.WaitForIdle
set cell=ActiveDocument.GetSheetObject("CH53").GetCell(1,10)
ActiveDocument.Variables("Get Growing Accounts").SetContent cell.text, True
set cell=nothing
End Sub
=sum(aggre(fabs(copy expression from column 😎 , dimension 1 used in straight table , dimension 2..ect )
erm sorry what do you mean by dimensions?
Nvm thanks for the help bro i got it by using the macro
Sub Get_Growing_Accounts
Application.WaitForIdle
set cell=ActiveDocument.GetSheetObject("CH53").GetCell(1,10)
ActiveDocument.Variables("Get Growing Accounts").SetContent cell.text, True
set cell=nothing
End Sub