Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I calculated a total of rack units which are planned in the data center plus total kw? Planned meaning which are in the system but not install yet but the power are know by the model . I'm using simple KPI measure. Please see attachment.
=sum(if(itemstate='Planned' and integrated_rack='True', power_kw, 0))
Use set analysis.
something like below
sum({<itemstate={'Planned'} , integrated_rack={'True'}>}
power_kw)
if you share a sample app can help further