Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I would like to calculate the balance of enterprises which is the substraction of the new and the closed enterprises. Here is the2 expressions for the new and the closed enterprises:
=Count(distinct {< [Municipality_Unit-municipality_name]= {'ΧΕΡΣΟΝΗΣΟΥ'}, [mitroo-03072017.Registration_Number] *=E({<[mitroo-03072017.Date] ={"$(=Maxstring({<[mitroo-03072017.Registration_Number]>}[mitroo-03072017.Date]))"}>}) >} [mitroo-03072017.Registration_Number])
=Count(distinct {< [Municipality_Unit-municipality_name]= {'ΧΕΡΣΟΝΗΣΟΥ'},
[mitroo-03072017.Registration_Number] *= E({<[mitroo-03072017.Date] ={"$(=MINstring({<[mitroo-03072017.Registration_Number]>}[mitroo-03072017.Date]))"}>})
>} [mitroo-03072017.Registration_Number])
I tried to put a minus between this 2 expressions to do the difference but it doesn't work. Any idea?
Thank you!
It is ok I managed to make it work finally but subtracting the two expressions. Sorry for the disturbance.