Power Platform Community Forum Thread Details

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

Categories:

Microsoft Dataverse with Power Apps