Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want expression to be written in Guage for calculating Profitability with given parameters -
Where
Profit is - P1,P2,P3....Pn
Value is - V1,V2,V3....Vn
Guage should calculate - Profitability -
(P1+P2+P3+....+Pn) / (V1+V2+V3+...+Vn)
div(Sum(Profit),Sum(value)) is not working in expression
Please guide
Thanks,
Vikas
as Per your expression Guage chart is showing result
is 4 is it correct?
Data I have provided should give me 5.1 as result in guage
Hi
as per data it was showing result is 5
yes answer is 5
is it ok
Hi please find the attached file
Ceil do not give me perfect value
I want
Profitability to be calculated as
(Sum of total profit) / (Sum of total Value)
Hi
as per data its giving the result like
4.693917269 |
if u want check in text object like :- =sum(TOTAL Profit)/sum( TOTAL value)
I got it
Sum(Profit)/Sum(Value) gave me the desired answer.
Thanks for the help.
Hi Vikas, if your answer is solved please mark correct/helpful answers to close the thread.