Hi @all
I have a confusion in getting a formula to calculate the consolidated rate using the trandate in the below formula in suiteanalytic workbook. Can the below formula date be set as dynamic to trandate instead of keeping it as static?
Formula: " TO_NUMBER({transactionlines.foreignamount#converted[1;2020-02-01]}) ". Can anyone suggest a formula to keep the bold date as dynamic to take the trandate of a transaction for calculation.
Thank you.