Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
can someone help me i am not able to calculate the percentage Q2 Vs Q1.
please find the expression im using help,
kindly help me with your suggestions
Num(
Num(
Count( DISTINCT{<Period_IssueView={'Quarter'},[Issue Status Name_IssueView]={'Open'},[Issue Severity_IssueView]={'High'},_Ind_IssueView={'Y'},[As of Date_View]={">=$(=vCurrentQuarterMaxDate) <=$(=vYourMaxDate)"}>} [Issue ID_IssueView])
-
Count( DISTINCT{<Period_IssueView={'Quarter'},[Issue Status Name_IssueView]={'Open'},[Issue Severity_IssueView]={'High'},_Ind_IssueView={'Y'},[As of Date_View]={">=$(vLast2Quarter) <=$(=vCurrentQuarterMaxDate)"}>} [Issue ID_IssueView]))
/
Num(Count( DISTINCT{<Period_IssueView={'Quarter'},[Issue Status Name_IssueView]={'Open'},[Issue Severity_IssueView]={'High'},_Ind_IssueView={'Y'},[As of Date_View]={">=$(vLast2Quarter) <=$(=vYourMaxDate)"}>} Total [Issue ID_IssueView]))
,'###%')
Thanks in Advance
Navin P
Which object are you calculating this percentage in?
Hi Navin,
I think you are looking for %Growth of Q1 vs Q2
% Growth = (Current -Previous)/Previous
Hi Sunny,Thanks for your reply
using As of date im calculating the Percentage B/W Q2 vs Q1
Hi Pon kaviyarasu, Thanks for your reply
i tried with your logic, i got the wrong number please find the below image
Sorry for my late reply
Q2 for CIB i have 9 issues,Q1 is 0, here i want to show 100%
But Q3 i have values for all LOBs now i want to allocate the 100% based on values,Please find the below expected result
LOB | Q1 | Q2 | Q2-Q1 | Q3 | Q3-Q2 |
AWM | 0 | 0 | 0% | 9 | 42.9% |
CF | 0 | 0 | 0% | 2 | 9.5% |
CIB | 0 | 9 | 100% | 10 | 47.6% |
ToTal | 0 | 9 | 100% | 21 | 100.0% |
Many Thanks
Navin