Forum Discussion

Irina's avatar
Irina
Contributor
18 days ago
Solved

Text field of Entity dimension in cube view

Dear all, Could you please advise how to show content of certain Text field of Entity dimension in cube view?  
Cube View
  • BenEppel's avatar
    BenEppel
    16 days ago

    If your using text2 then you would need to change it. It is, you will just need logic to clean the string. Something like this should work.

    Dim textVal As String = api.Entity.Text(EntityID, 1, False, False)
Dim taxRateStr As String = ""

If Not String.IsNullOrEmpty(textVal) Then
    Dim startIndex As Integer = textVal.IndexOf("CIT=")
    Dim endIndex As Integer = textVal.IndexOf(",", startIndex)

    If startIndex >= 0 AndAlso endIndex > startIndex Then
        taxRateStr = textVal.Substring(startIndex + 4, endIndex - (startIndex + 4))
    End If
End If

Dim TaxRate As Decimal = taxRateStr.XFConvertToDecimal() / 100D

     

Irina's avatar
Irina
Contributor
18 days ago

Dear BenEppel, thank you for your answer! Could you please advise is it possible to use text field in cube view not only as header (instead of entity name) but also use it for calculations. In text field I have income tax rate different for each entity and need to use each tax rate for calculation of income tax by entities. Could you also please advise can I also add entity name in the same report.

DanielWillis's avatar
DanielWillis
Valued Contributor
18 days ago

Hi Irina. I just want to confirm because it doesn't sound right. Are you saying you're storing the tax rate in the text property of an entity and want to use it to calculate something on the report?