3
Views
2
Comments
Solved
How Can I use Rich Widget List Sort Column in a table where I have one calculated att

Hi everybody,

How Can I use Rich Widget List Sort Column in a table where I have one calculated attribute? 


In my example I have a calculated attribute "ValueWithVat", the formula is ProductSale.Value * ProductSale.Quantity * (1 + ProductSale.Vat / 100). 

My question is how can I use this calculated attribute in List Sort Column because the property column of the list sort column is "{Entity}.[Attribute]". I did {ProductSale}.[ValueWithVat]" and didn't work. 

Any suggestion? 



Thanks in advance. 

Best regards,

 FC

Rank: #96
Solution

Hello Fábio,

Hope you're doing well.

That calculated attribute does not belong to the entity :) so you shouldn't define it as "{ProductSale}.[ValueWithVat]".


Please try to define the column just as:

"[ValueWithVat]"


Hope that this helps you!


Kind regards,

Rui Barradas

Hi Rui,


Works perfectly!

Thank you so much!


Best regards,

FC