10 Replies Latest reply: Feb 1, 2018 1:38 PM by AJAY SINGH

# Show Quarterly % in Expression

Hi Members,

I am not able to group the expression in percentage on the basis of quarter.

I have the scenario given below:-

 Quarter(as Dimension) Sum(expression1)+Sum(expression2) \$313,962.93 Q1 \$36,260.47 Q1 \$24,627.60 Q1 \$26,368.20 Q2 \$27,909.51 Q2 \$26,747.78 Q2 \$27,576.78 Q3 \$25,242.10 Q3 \$24,848.75 Q3 \$24,820.91 Q4 \$23,270.59 Q4 \$20,847.45 Q4 \$25,442.78

i am having Quarter as Dimension and other as sum of two expression. so the sum ( exp1 and exp2) which total is bifurcate to different quarters which is good.

But my question is , i need the percentage of  each Quarter. like percentage for Q1,Q2,Q3,Q4?

Can any body help me out from this?

• ###### Re: Show Quarterly % in Expression

What is the expected output for the sample data provided?

• ###### Re: Show Quarterly % in Expression

Sum(Q1\$value)/sum(Q1\$ value+Q2\$ value+Q3\$ value+Q4\$ value)  *100 respectively for  Q2 ,Q3,Q4 which is in percentage form

• ###### Re: Show Quarterly % in Expression

Something like this

(Sum(expression1)+Sum(expression2))/(Sum(TOTAL expression1)+Sum(TOTAL expression2))

• ###### Re: Show Quarterly % in Expression

i have tried sum(total) but it shows blank. Do u have any alternate way

• ###### Re: Show Quarterly % in Expression

May be if you can share a sample, I might be able to look into it. Difficult to guide without knowing what all you have

• ###### Re: Show Quarterly % in Expression

These are my two expressions which gives the sum of \$ value column. How can we do the Quarter percentage in this

=(sum({< [Month End]={'\$(vVariable)'},nDateMonth={'<\$(vStartMonth)'}>} [Budget])  /  \$(vDividend)) +

(sum({< [Month End]={'\$(vVariable)'},nDateMonth={'>=\$(vStartMonth)'}>} [Budget])  /  \$(vDividend))

• ###### Re: Show Quarterly % in Expression

Don't know.... ... expressions alone don't really help understand what else might have... image or sample might help

• ###### Re: Show Quarterly % in Expression

In this i need % values Quarterly with the help of using that expression.

for ex:-

Q1\$ values / (Q1 \$ value+Q2 \$ value+Q3 \$ value+Q4 \$ value)

like wise for Q2,Q3,Q4 as well with help of expression.

Quarter is dimension here and in \$ values is used as expression .

• ###### Re: Show Quarterly % in Expression

And this isn't working?

=((sum({< [Month End]={'\$(vVariable)'},nDateMonth={'<\$(vStartMonth)'}>} [Budget])  /  \$(vDividend)) +

(sum({< [Month End]={'\$(vVariable)'},nDateMonth={'>=\$(vStartMonth)'}>} [Budget])  /  \$(vDividend)))/

((sum(TOTAL {< [Month End]={'\$(vVariable)'},nDateMonth={'<\$(vStartMonth)'}>} [Budget])  /  \$(vDividend)) +

(sum(TOTAL {< [Month End]={'\$(vVariable)'},nDateMonth={'>=\$(vStartMonth)'}>} [Budget])  /  \$(vDividend)))