# Deployment Framework

cancel
Showing results for
Did you mean:  Contributor III

## 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?

1 Solution

Accepted Solutions  MVP

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)))

10 Replies  MVP

What is the expected output for the sample data provided?  Contributor III
Author

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

Something like this

(Sum(expression1)+Sum(expression2))/(Sum(TOTAL expression1)+Sum(TOTAL expression2))  Contributor III
Author

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

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  Contributor III
Author

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))  MVP

Don't know.... ... expressions alone don't really help understand what else might have... image or sample might help  Contributor III
Author 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 .  MVP

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))) 