How do I Currency Convert All Values to Chosen Currency in Drop Down?
Hi all, I need a bit of help referencing a currency table and using the exchange rate provided in that table, against the relevant date, to convert the value to the currency the user has selected in a drop down on the report. When this currency from the drop down is selected I need all the values in my table ('table A') changed using this exchange rate. The maybe tricky part is that for each row in Table A (each Asset listed in the row) which contains the Asset Value, displays the native currency value as standard as per in the model view the currency column in Table A. So there are several different native currencies listed/referenced, so the native currency against the asset needs to be looked up, this is then used in the currency conversion rates table against the date against for the converstion and used to adjust the value. The added problem is that ECB only give a rate to Euros. So in all cased the amount will need to be converted to Euros and then out to the native currency again for situations where the asset's native currency is DKK , and the user has selected something like AUD for the value to be converted to. Example Data subset from EBC in past 90 Days <Cube time="2022-06-30"> <Cube currency="DKK" rate="7.4392"/> <Cube currency="AUD" rate="1.5099"/> </Cube> [EUR -> EUR] * [EUR -> DKK] [1/1.0000] * [7.4392] = 7.4392 (this one is simple as the rate matches that from the ECB extraction) [AUD -> EUR] * [EUR -> DKK] [1/1.5099] * [7.4392] = 4.9269 I've attached a sample file with this dummy data in for reference. There is an API connection to ECB to get the currency conversion rates for relevant currencies I need. It's a bit meaty this one but any help at all I'd be grateful for. Sample File
Calculating UK National Insurance rates
Dear all, I am working on a costing overview but are challenged by adding UK National Insurance (NI) on top of the base salary for our employees. Employees are categories into different National Insurance Category Letters following the below rate structures on a weekly basis. My data is structured in daily shifts per employee with base salary [ActualCost] and NI Category in seperate coloums as seen below. Initial idea is to do a SWIFT/IF statement related to a seperate NI Cateogry table, however I cant get my head around it as the daily costs needs to be summed into Weekly costs in order to calculate the correct NI payable. Thank you so much in advance.
