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?
Transactions: Base24PosTransactionSummary.TRANCNT Base24PosTransactionSummary.TRANCNT/Base24PosTransactionSummary.TRANCNT3 %
Expected result: # Result %
Solved! Go to Solution.
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.
I tried it but it is not letting me use =Base24PosTransactionSummary.TRANCNT/Base24PosTransactionSummary.TRANCNT2 only.
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.
Great. Got it working. How can I eliminate the decimal point of a division in the label?
@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.