Hi..
I have Ultragrid with a dropdown column named "currency" with two values "Euro", "Dollar" and another column named "total".
I have two labels to get the sum of totals for rows which currency is dollars and the other to get the sum of euros.
I tried multiple formulas with no chance.
Could you please help me to do that using Calc manager.
Regards,
Hi,
Thank you for posting in our forums.
What I would suggest to do in your case is to create two unbound, hidden columns for the “Total Dollars” and the “Total Euros”. You can use the InitializeRow event to set the values for these columns. If the value in the "Currency"column is euro, set the “Total Dollars” column value to 0 and the “Total Euros” column value to the value in the "Total"column and vice versa. Then the “Total Dollars” label’s formula will be “sum([Total Dollars])” and the “Total Euros” label formula will be “sum([Total Euros])”.
I have attached a sample demonstrating this suggestions.
Please let me know if you have any additional questions.
Thank you, it works good