cancel
Showing results for 
Search instead for 
Did you mean: 

when i make it section value it not showing?

Former Member
0 Kudos

Hi Experts,

when make add dimension in report .It showing value. Then if I change to section value is showing .here I have attached screen shot. Please find the attachment.

After make it section

Accepted Solutions (0)

Answers (2)

Answers (2)

arijit_das
Active Contributor
0 Kudos

can u share a screenshot of structure view ?

also, what is the formula for the value column?

Former Member
0 Kudos

Hi,

1 st screen shot is without section

second screen shot is with section.

arijit_das
Active Contributor
0 Kudos

what is the formula for v_TSI Avg.MKT ?

Former Member
0 Kudos

HI

(Sum(Count([Leave].[L01 Calendar day]) Where ( ([v_Completed-Prospect] >0 ForEach([Leave].[L01 Calendar day]))  And [TSI]=1 )ForEach([Leave].[L01 Employee  Name])))/(Sum([TSI]Where([v_Completed-Holidays]>0)ForEach([Leave].[L01 Employee  Name])))

former_member186586
Active Participant
0 Kudos

Hi Manikandan , can you put and hide [Divisional Office] to body. work?

arijit_das
Active Contributor
0 Kudos

what if you use the below formula instead :

=Sum(Count([Leave].[L01 Calendar day]) Where(([v_Completed-Prospect] >0 ForEach([Leave].[L01 Calendar day];[Divisional Office])) And [TSI]=1)ForEach([Leave].[L01 Employee  Name]))/Sum([TSI]Where([v_Completed-Holidays]>0)ForEach([Leave].[L01 Employee  Name];[Divisional Office]))

Former Member
0 Kudos

Now also it is not working

kohesco
Active Contributor
0 Kudos

Wiggle in "in section" in your formula and it could do the trick

Former Member
0 Kudos

How should do the trick..

kohesco
Active Contributor
0 Kudos

it's hard to reproduce but in section could enpower your formula

former_member186586
Active Participant
0 Kudos

whats the formula for second column

Former Member
0 Kudos

Hi Erdem,

I didn't use formula for section.

Former Member
0 Kudos

Simply make it section for first coloum