Error in expression ')' expected.

[generalfinance]

Hello everybody,
I can't write the following formula correctly:

Interval ({<(sum (date ([Expiry Date and], 'DD / MM / YYYY') - date ([Practice Date and], 'DD / MM / YYYY')))) = {"> = $ (Start of Month ) <= $ (vDataRifA) "}>}) * Nominale_a /
Sum ({<[Practice Date and] = {"> = $ (Start of Month) <= $ (vDataRifA)"}>} Nominale_a)

Error in expression ')' expected.

You can help me?
Thanks

[usamabinsadiq]

Hi,

please try this, i hope this resolves your issue.

Interval ({<(sum (date ([Expiry Date and], 'DD / MM / YYYY') - date ([Practice Date and], 'DD / MM / YYYY'))) = {"$(= '>=' & date(Start of Month ) & '<=' & date(vDataRifA) )"}>})
*
Nominale_a
/
Sum ({<[Practice Date and] = {"$(= '>=' & date(Start of Month) & '<=' & date(vDataRifA) )"}>} Nominale_a)

regards 

[generalfinance]

Hi usamabinsadiq,
thanks for the help but unfortunately i still have this error

"Error in expression ')' expected"

[Anil_Babu_Samineni]

[Start of month] is the variable? If so try this

Sum(If(date ([Expiry Date and], 'DD / MM / YYYY') - date ([Practice Date and], 'DD / MM / YYYY')>=$(Start of Month ) and date ([Expiry Date and], 'DD / MM / YYYY') - date ([Practice Date and], 'DD / MM / YYYY')<=$(vDataRifA), Nominale_a))/Sum ({<[Practice Date and] = {"> = $ (Start of Month) <= $ (vDataRifA)"}>} Nominale_a)

[generalfinance · Accepted solution]

Hi Anil,
yes [Start of month] is a variable for precision = date (MonthStart (vDataRifA), 'DD / MM / YYYY'), now I no longer have the error Error in expression ')' expected, but the correct calculation is this :

Sum (If (date ([Expiry Date and], 'DD / MM / YYYY') - date ([Practice Date and], 'DD / MM / YYYY')> = $ (Start of Month) and date ([Expiry Date and ], 'DD / MM / YYYY') - date ([Practice Date and], 'DD / MM / YYYY') <= $ (vDataRifA) * Nominale_a)) /  Sum ({<[Data Pratica and] ={ ">=$(VinizioMese)<=$(vDataRifA)"}>}Nominale_a)

Thank you very much for helping

[generalfinance]

how do I manage if with multiplication?

[generalfinance]

how can I say that the sum of the difference between the two dates must be between the two variables?

sum(date([Data Scadenza and],'DD/MM/YYYY') - date([Data Pratica and],'DD/MM/YYYY')) = { ">=$(VinizioMese)<=$(vDataRifA)"}