Can Legend label reflect a result of an arithmetic division inserted in the Custom Legend label?

[Jerry]

Hello;

Can the label within Custom Legend mange arithmetic algoritm and present the result on the Legend label? There where clause already manage it, can it be done for the legend?

For example;

Label:

Transactions: Base24PosTransactionSummary.TRANCNT Base24PosTransactionSummary.TRANCNT/Base24PosTransactionSummary.TRANCNT3 %

Expected result:   #  Result %

[LouisZ]

Hi Jerry,

One possible way to do this would be to create a user-defined field using the calculations you want and then display the user-defined field in the custom legend label. Make sure that you use a calculated field though, so that it doesn't intepret your calculation as a string.

[Jerry]

I tried it but it is not letting me use  =Base24PosTransactionSummary.TRANCNT/Base24PosTransactionSummary.TRANCNT2 only.  

 

[Shoaib_Dilawar]

Hi @Jerry,

you'd need to change the 'Field Type' to Numeric if you are operating on Numeric fields. That should fix the issue you are facing.

[Jerry]

Great. Got it working. How can I eliminate the decimal point of a division in the label?

[Shoaib_Dilawar · Accepted solution]

@Jerry, you can use RONND() function to either round it completely, or round it to 2 digits.

ROUND(TRANCNT/TRANCNT2, 2) for 2 decimal or

ROUND(TRANCNT/TRANCNT2) for non floating number.

[Jerry · Accepted solution]

@Shoaib_Dilawar

It worked. Thank you for you help.