
Announcements
Hi,
I'm trying a new Dataverse database. I'd like to do some advanced calculation that I had in a Excel sheet directly in the database (to use it in an Apps after).
Is it possible to have a formula Column, based on another formula column (like in Excel, I'd like to have separated columns to do my calculation to keep a 'clear' db).
When I'm trying to do so, my first column works perfectly, but I can't create the second one, I have this error message :
"Unexpected characters. The formula contains 'Eof' where 'ParenClose' is expected"
For more context :
1st column : DiffAnnee = DateDiff(DateBail;DateDebutFactu;TimeUnit.Years)
2nd column : Test = DiffAnnee
Best,
Aurélien