topic Show Quarterly % in Expression in Archived Groups

Show Quarterly % in Expression

ajaysingh285 — Tue, 22 Jul 2025 17:59:49 GMT

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

sunny_talwar — Thu, 01 Feb 2018 17:24:08 GMT

What is the expected output for the sample data provided?

Re: Show Quarterly % in Expression

ajaysingh285 — Thu, 01 Feb 2018 17:29:18 GMT

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

sunny_talwar — Thu, 01 Feb 2018 17:30:55 GMT

Something like this

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

Re: Show Quarterly % in Expression

ajaysingh285 — Thu, 01 Feb 2018 18:01:39 GMT

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

Re: Show Quarterly % in Expression

sunny_talwar — Thu, 01 Feb 2018 18:02:34 GMT

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

ajaysingh285 — Thu, 01 Feb 2018 18:12:22 GMT

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

sunny_talwar — Thu, 01 Feb 2018 18:13:52 GMT

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

Re: Show Quarterly % in Expression

ajaysingh285 — Thu, 01 Feb 2018 18:20:49 GMT

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

sunny_talwar — Thu, 01 Feb 2018 18:27:37 GMT

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

Re: Show Quarterly % in Expression

ajaysingh285 — Thu, 01 Feb 2018 18:38:51 GMT

you made it Thanks sunny:)