Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
I am trying to calculate the premium for the policies expiring between 01.01.2018 and 31.01.2018.
I have entered into my formula:
sum({$<ExpiryDate={'<=$(=01.01.2018)>=$(=30.03.2018)'},[Quote Status]={'Renewal'}>}NetWrtPrem*NWP_FX)
but it gives me wrong outcomes.
Can somebody tell me how to correct his formula?
Many thanks.
Best regards,
Jan
Hi,
try this:
sum({$<ExpiryDate={"$(= '>=' & '01/01/2018' & '<=' & '31.01.2018')"},[Quote Status]={'Renewal'}>}NetWrtPrem*NWP_FX)
Make sure that your ExpiryDate field have this format: DD.MM.YYYY
Hi,
try this:
sum({$<ExpiryDate={"$(= '>=' & '01/01/2018' & '<=' & '31.01.2018')"},[Quote Status]={'Renewal'}>}NetWrtPrem*NWP_FX)
Make sure that your ExpiryDate field have this format: DD.MM.YYYY
May be this
Sum({$<ExpiryDate = {">=01.01.2018<=30.03.2018"},[Quote Status] = {'Renewal'}>} NetWrtPrem*NWP_FX)
Hi stalwar1,
can you please tell us the main difference between these 2 working solutions ?
I use both depending on the result I have..
They are the same exact solution... you are using a dollar sign expansion... which will be evaluated to what I have ... so they are two ways of writing the same thing
thank you
sum({$<ExpiryDate={'>=''01.01.2018''<=''30.03.2018'''},[Quote Status]={'Renewal'}>}NetWrtPrem*NWP_FX)