- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Functions P() and E() doubt
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use variable inside E and P....
Use like below..
=count( {$<ID_COMPANY=E({1<LEVEL={">$(=vLevel)"}>})>} DISTINCT ID_COMPANY )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your prompt answer!!
Do you know if it is possible to use a the value in another expression (column)?
thkxs
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you upload your sample file or sample apps?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Replace Column(6) for your expression.
Best Regards.
Tonial.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Column(6) does not seems to work. If I write the values it works.
Find example attached.
Regards
Javier
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,