Pull Currency in Quickview

[tdugas]

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.

[alyssamertes]

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.

[tomdarnall]

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!