topic Re: Substraction of 2 expressions in Connectivity & Data Prep

Substraction of 2 expressions

gianniko — Thu, 18 Jul 2019 15:20:50 GMT

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!

Re: Substraction of 2 expressions

sunny_talwar — Thu, 18 Jul 2019 17:02:00 GMT

Where exactly are you trying to do this calculation? I mean to ask which type of object?

Re: Substraction of 2 expressions

gianniko — Thu, 18 Jul 2019 18:02:09 GMT

I want to subtract the first request by the second! (they are 2 different request your can see the MIN in the first and the MAX in the other one)

Re: Substraction of 2 expressions

sunny_talwar — Thu, 18 Jul 2019 18:20:08 GMT

But is there a dimension? What is it?

Re: Substraction of 2 expressions

gianniko — Fri, 19 Jul 2019 08:13:53 GMT

Yes it counts a number, it's written Count(…) as you can see

Re: Substraction of 2 expressions

sunny_talwar — Fri, 19 Jul 2019 11:14:51 GMT

I feel like we are living in two different worlds. I am asking how are you, and you are telling me that my car is giving me problems. Do you even understand my question?

Re: Substraction of 2 expressions

gianniko — Fri, 19 Jul 2019 15:26:26 GMT

Apparently not, sorry..

Re: Substraction of 2 expressions

sunny_talwar — Fri, 19 Jul 2019 15:28:36 GMT

Do you at least understand what a dimension is? If you do.... all I am asking is that are you using this in a chart object where you have some dimensions? What are those dimensions?

Does that clarify?

Re: Substraction of 2 expressions

gianniko — Fri, 19 Jul 2019 15:55:30 GMT

It is used in a table but as a measure not a dimension.. Not sure I understood though..

Re: Substraction of 2 expressions

sunny_talwar — Fri, 19 Jul 2019 16:27:09 GMT

Are you able to share a sample where we can see the issue? If not, then may be someone else might be able to help you better here

Re: Substraction of 2 expressions

gianniko — Fri, 19 Jul 2019 17:12:22 GMT

It is ok I managed to make it work finally but subtracting the two expressions. Sorry for the disturbance.