Hi - 2 questions below - thank you!
(1) this seems like a stupid question but I’ve searched around without much luck. I’m currently using a text element to pull dynamic data in that I want formatted as currency. The data field is set as a number but it’ll still pull in as e.g. 1250 instead of $1,250. I’m able to show the same field as an input element with “initial content” as the number displayed as currency, but not a text element. Any suggestion?
(2) I’m also trying to calculate simple formulas in text elements, but using the ‘formula’ option only pulls up 4 irrelevant options… for example, I’d like to calculate profit as Revenue (text element) minus Cost (text element). For example, revenue of $1,000 minus Cost of $400 spits out Profit of $600. Any suggestions on this?
Thank you very much!