This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
HI guys!
So, i have a list of credit card IDs and their corresponding balance.
The card IDs are then linked to clients. (clients table & credit cards table)
The credit card provider allows us to download a CSV file with card ID and Balance.
I would l...
Hi im trying to get to “Total Spent In USD”
Currently i have “Ammount Spent in Original Currency” and “Currency”
I (think) i want an If statement in an If statement, like in excel.
But this is giving me an error everytime i try it.
Whats the best wa...
Julian_Kirkness:
This will work fine if you want a single currency rate used in your calculation - however if you need to do the calculation for the date the transaction took place based upon the rate held at the time then this is currently a pr...
