Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to achieve the result 16 % at the text box in my chart -
Here is the expression -
=Num(Aggr(Count({<NextWardIdentifier={'TLR','TRANSIT','HKHTL'},[Ward Episode End Date.FinancialYear]={'$(=Max([Ward Episode End Date.FinancialYear]))'},[Ward Episode End Date.Month]={'$(=Max([Ward Episode End Date.Month]))'}>}[Total Ward Episodes])/(Count({<NextWardIdentifier={'TLR','TRANSIT','HKHTL','NA'},[Ward Episode End Date.FinancialYear]={'$(=Max([Ward Episode End Date.FinancialYear]))'},[Ward Episode End Date.Month]={'$(=Max([Ward Episode End Date.Month]))'}>}[Total Ward Episodes]) - Count({<NextWardIdentifier={'NA'},[Episode Mode of Separation Code]={'9'},[Ward Episode End Date.FinancialYear]={'$(=Max([Ward Episode End Date.FinancialYear]))'},[Ward Episode End Date.Month]={'$(=Max([Ward Episode End Date.Month]))'}>} [Total Ward Episodes])),[Ward Episode End Date.FinancialYear],[Ward Episode End Date.Month] ) ,'#,##0.#%')
Dim : =[Ward Episode End Date.Month],=[Ward Episode End Date.FinancialYear]
Thanks in advance
Hi
PFA
Hi
Try like Avg() or Count() or sum() before Aggr() based on ur requirement
=Num(Avg(Aggr(Count({<NextWardIdentifier={'TLR','TRANSIT','HKHTL'},[Ward Episode End Date.FinancialYear]={'$(=Max([Ward Episode End Date.FinancialYear]))'},[Ward Episode End Date.Month]={'$(=Max([Ward Episode End Date.Month]))'}>}[Total Ward Episodes])/(Count({<NextWardIdentifier={'TLR','TRANSIT','HKHTL','NA'},[Ward Episode End Date.FinancialYear]={'$(=Max([Ward Episode End Date.FinancialYear]))'},[Ward Episode End Date.Month]={'$(=Max([Ward Episode End Date.Month]))'}>}[Total Ward Episodes]) - Count({<NextWardIdentifier={'NA'},[Episode Mode of Separation Code]={'9'},[Ward Episode End Date.FinancialYear]={'$(=Max([Ward Episode End Date.FinancialYear]))'},[Ward Episode End Date.Month]={'$(=Max([Ward Episode End Date.Month]))'}>} [Total Ward Episodes])),[Ward Episode End Date.FinancialYear],[Ward Episode End Date.Month] ) ),'#,##0.#%')
Hi Mayil,
its not working. its showing 0.0 % when trying with Count() and Sum().
Even if I selected the Year and Month.
Can you send the sample file to verify?
Hi Mayil,
Here i s the sample.
Hi
PFA
Thank you very much.