Sum(Profit) - last year

[#1]

Hello,

Simply. I have fields "Profit"    "DYear"    and   "DLastYear"

I need to calculate sum(profit) of Dyear  -minus-   sum(profit) of DlastYear

I don't know how to calculate sum(profit) in a period,  e.g  sum(profit in Dyear)  and that's my problem

All help very appreciated

[#2]

"no data to display"   if my script is modified or unmodified using the second one. So, still not working
  Ah...Thanks for your help so far though!

[#3]

Any other ideas?

[#4]

Any ideas?

[tresesco]

Hi Darren,

Please share a sample app. If you are worried about the data security, you can always scramble the data and upload.

[Anonymous]

Hi tresesco...

could you please explain {"$ (= Max (Year))"}, obvious that Max (Year) is the biggest year of available data,

but I do not understand the $ symbol does?

double quotes make a difference between {"$ (= Max (Year))"} or {$ (= Max (Year))} latter becomes gray in the formula?

I thank you in advance!

[tresesco]

Hi,

It is simple dollar sign expansion used along with set analysis . For better understanding, see page17,18 of the attached doc.