03-05-2024 11:17 AM
Is there a way to pull the functional currency in a Quickview, for example we have a Quickview showing entity and account (cash) in the rows and time in the columns. I would like to pull the entity, the functional currency of each entity.
03-05-2024 11:45 AM
I think you can do a C#Currencies.base as a row field (if your entities are in the rows), but then you might get both local currency and USD (2 rows for each entity). For a getCell instead of Quickview, you can use =@XFGetMemberInfo("Currency","Entity",$C12).... where C12 is the entity name. You could tack this GetCell Formula to the side of a QuickView if you can't get the QuickView to do what you want.
03-05-2024 03:43 PM
You can create a U8 member with a dynamic calc to do this. We actually have dozens of U8 members to grab various tags. For this one, you can use a simple...
Return api.Entity.GetLocalCurrency(api.Pov.Entity.MemberId).Name
As a U8 member, you can use it in a cube view, or quick view.
Good luck!