Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one give the right set analysis for the below expression
=if(Metric=APPROVEDNOTUSED,sum({<RUNTIME={"=max(RUNTIME)"}>}APPROVEDNOTUSED))
try this
sum({<RUNTIME={"=max(RUNTIME)"},Metric={'APPROVEDNOTUSED'}>}APPROVEDNOTUSED)
Hi Naresh,
Try:
=if(Metric=APPROVEDNOTUSED,sum({<RUNTIME={$(=max(RUNTIME))}>}APPROVEDNOTUSED))
You can try something like this:
sum({<RUNTIME={$(=max(RUNTIME))},Metric={'APPROVEDNOTUSED'}>}APPROVEDNOTUSED)
Hope it helps
try this:
=sum({<Metric={'APPROVEDNOTUSED'},RUNTIME={'=$(=max(RUNTIME))'}>} APPROVEDNOTUSED))
try this
sum({<RUNTIME={"=max(RUNTIME)"}>}if(Metric='APPROVEDNOTUSED',APPROVEDNOTUSED))
Dear Naresh,
Please try this one,
=Sum({<Metric = {'APPROVEDNOTUSED'}, RUNTIME = {'$(=max(RUNTIME))'}>} APPROVEDNOTUSED)
Kind regards,
Ishfaque Ahmed