Forum Discussion
Need help with a formula
I need to create a formula that summarize numbers in table based on column text i decide. This is my table I want it to do this: accountNumber = 5520 summarize "amountInBaseCurrency" ...
I just did some more testing, and it seems like it works if i set "accountNumber" to format as TEXT - but that does not look logically correct to me, as account number is a "number"?
Is there a way i can format it in the function, without having to format the whole table?