Dimension Missmatch,Boolean to list convertion

riyaserenajo

Hi, 

can anyone plz help me in below queries:

1. 

	Line Item	Format	Dimension	Fomula
INP01	Status	List1(Samelist for INP02)	Geo	IF 'DAT7 - DATA'.ACount[SUM: 'DAT007 - DATA'.Geo] > 0 THEN 'SYS035 - Lookup Module'.'R?.R' ELSE 'SYS035 - Lookup Module'.'R?.P'
INP02	Status1	List1	G6 - subregion	IF INP01.Status='SYS035 - Lookup Module'.'R?.R' THEN 'SYS035 - Lookup Module'.'R?.S ELSE 'SYS035 - Lookup Module'.'R?.P'
SYS035 - Lookup Module	R	List1		R
SYS035 - Lookup Module	S			S
SYS035 - Lookup Module	P			P

 

the above-highlighted formula is not working because of level mismatch. What needs to do if we need to refer Geo line item in G6-Sub region module. 

 

2. 

 

	Line Item	Format	Dimension	Fomula
INP01	Status	List1(Samelist for INP02)	Geo	IF 'DAT7 - DATA'.ACount[SUM: 'DAT007 - DATA'.Geo] > 0 THEN 'SYS035 - Lookup Module'.'R?.Ready' ELSE 'SYS035 - Lookup Module'.'R?.Pending'
INP02	Status1	List1	G6 - subregion	IF INP01.Status='SYS035 - Lookup Module'.'R?.P' AND DAT7.Progress=FALSE THEN 'SYS035 - Lookup Module'.'R?.P
DAT7	Progress?	Boolean	Employees	IF  EmpLead? THEN   Segment ELSE FALSE

 

As highlighted above how to use a boolen formula in List line item.

 

3.

 

	Line Item	Format	Dimension	Fomula
DAT1	Employee	TEXT	Employees	Employess.Display Name
Geo	Geo list
Cluster	Cluster list
Sub-cluster	Sub-cluster List
EmployeeCount?	????	How to get the count in DAT1

 

 

 

Berge251

Simple quiestion: Is changing the type of seed from boolean to Boolean possible in your case or are you restricted? 

ePayitonline Login

riyaserenajo

yes