Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there ,
Please kindly suggest with the set analysis expression :
Expression :
%Death by /Death in whole
Dimension : =[$(vDisplayedBy)]
Expression :
Sum({$<Mode_Desc={'Death'}>}Measure)/Sum({$<[Mode_Desc]={'Death'},[$(vDisplayedBy)]=>} Measure)
Sum(Measure)/Sum(Total <[$(vDisplayedBy)]>Measure) , I need to put the condition Mode_Desc={'Death'}
But my expression not working
Variable details:
set vDisplayedBy='Facility';
Can you attach the sample app.
Hi @ashmitp869
Try like below
Sum({<Mode_Desc={'Death'}>}Measure)/Sum(Total <[$(vDisplayedBy)]> {<Mode_Desc={'Death'}>}Measure)