Functions P() and E() doubt

[Anonymous]

Hello,

I am trying to create a KPI with the following formula:

   =count( {$<ID_COMPANY=E({<LEVEL={">$(=vLevel)"}>})>} DISTINCT ID_COMPANY )

OR

   =count( {$<ID_COMPANY=E({<LEVEL={">$(=Column(6))"}>})>} DISTINCT ID_COMPANY )

But it is not working right. I am suspecting that I cannot use vars neither reference other expresions inside those functions.

* Does anybody can confirm this?

* Do you have any alternative?

Thanks in advance,

Javier

[MK_QSL]

You can use variable inside E and P....

Use like below..

   =count( {$<ID_COMPANY=E({1<LEVEL={">$(=vLevel)"}>})>} DISTINCT ID_COMPANY )

[Anonymous]

Thanks for your prompt answer!!

Do you know if it is possible to use a the value in another expression (column)?

thkxs

[MK_QSL]

Can you upload your sample file or sample apps?

[fernando_tonial]

Replace Column(6) for your expression.

Best Regards.

Tonial.

[Anonymous]

Hello,

Column(6) does not seems to work. If I write the values it works.

Find example attached.

Regards

Javier

[deepakqlikview_123]

Hi Javier ,

Can you please tell me how

=count( {$<CMT_NNUMSCH=E({$<NIVEL_HIJO={">Column(3)"}>})>} DISTINCT CMT_NNUMSCH )

Will works.I am not able to undershand.

Thanks,