Skip to Content (Press Enter)
2022-10-11 21-19-04
Fábio Miguel Ferreira Coelho
141Views
2Comments
Solved
How Can I use Rich Widget List Sort Column in a table where I have one calculated att
Question
Traditional Web

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

3
0
25 Nov 2020
Copy Link
2020-05-07 18-53-00
Rui Barradas
 
MVP
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

1
0
25 Nov 2020
Copy Link
2022-10-11 21-19-04
Fábio Miguel Ferreira Coelho

Hi Rui,


Works perfectly!

Thank you so much!


Best regards,

FC

3
0
26 Nov 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.