cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
slalithprasad
Helper I
Helper I

Calculated Colum Error

I have two tables Products and Orders. I am trying to create a Calculated Column in Orders Table called (TotalPrice which is Price of Selected Product * Quantity) and I get this error -  

 

The crf9a_totalprice field has an invalid XAML formula definition.

 

my price from Product table is Currency type, Quantity and TotalPrice are Whole Number.

3 REPLIES 3
rampprakash
Super User
Super User

Dear @slalithprasad,

 

Hope you are doing good. Please find the Limitations for Calculated Fields,

 

rampprakash_0-1640231683230.png

 

As it is referencing from another table we are getting this error.

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

 

slalithprasad
Helper I
Helper I

@rampprakash  nope, it works fine if product table price field is also a whole number, have checked it. I think the issue is with datatypes. anyways I am looking for confirmation. thank you 

Hello @slalithprasad,

 

Can you please try with Decimal Number as the Currency field will accept Decimal Values, if not its good to go with Currency Value DataType

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,756)