Currency conversion in People Story reports

[prachisathe]

We are a global company and trying to build a headcount in employee numbers and base compensation $$s. Our compensation information is stored in employee's base currency. Have any of you built such story that can group all employees data in USD by applying currency exchange rates?

[SanneKaasgaard]

Hi,
I have not yet created such a report as I have not found a good way to do so. My thoughts on building such a query would be to create a long if-calculation on a new value (e.g. USD-base compensation) with all the currency conversion rates for the current year. This would mean that it would need to be refreshed every year.
I.e. if only USD, DKK and SEK existed as currencies:

If(currency="DKK", base salary*7.4, if(currency=SEK, basesalary*6.4, base salary)))

Then I would use that new field "USD-base compensation" in the story.

But as it seems like a tedious and not too clever way of calculating it, I have not tried it out yet, so I am following along if you get a good reply from someone else on this issue.

/Sanne

[marianolanza]

Hi @Aneta_Krysiak ,

In our instance, we have this in Canvas , Advance Reporting. Check your Foundation Tables. As shared before, we are not seeing this in Story data schema yet :(...hope SF add this in the upcoming future.

I don't know if this is a "standard" configuration or this is something was built for our instance. You can check with your SF support.

[Aneta_Krysiak]

Hi @marianolanza 

thank you, I've this table.

Regards,

Aneta

[CSmith]

Hi @Aneta_Krysiak 

My guess is that the currency rate you see is the inverse of the rate in the table. I'm not sure when the rates were loaded but based on the conversion rate today, it looks pretty close for the EUR GBP pairing. Currency rates only need to be provided in one direction in the table but both directions can be calculated.

Hope this helps.

Christian