hi need urgent reply

[#1]

hi ...can any one help me this issue...

I have a metric "AHOT Minute" and now i need to disply this in expression section of chart properties for that i used below defination to get AHOT Minutes,

=

sum(AHOT_MINUTES

)

So for this getting value like below

AHOT Minutes

50,701,420.40

But i want to disply AHOT minutes in the form of Days or Months.....is it possible to get like that ....?

[Gysbert_Wassenaar · Accepted solution]

sum(AHOT_MINUTES)/1440 will give you the number of days. Divide it again by 30 and you approximately have the number of months

[sushil353]

if you divide the above fig by (24*60) you will get days and further if you divide it by (30*24*60) then you will get month.

is it what you are looking for...?

Regards

Sushil

[#4]

Yeah thanks for that rply ...now i am getting result like this ...

2868.1940740741              Days(s)

But now the cace is need to disply only 3 digits after point like  2868.194, pls help me to get that result...

[n1ef5ng1]

Properties -> Number -> Select field -> decimal -> set it as 3

[#6]

Yeah thanks for that rply ...now i am getting result like this ...

2868.1940740741              Days(s)

But now the cace is need to disply only 3 digits after point like  2868.194, pls help me to get that result...

[#7]

Yeah thanks for that rply ...now i am getting result like this ...

2868.1940740741              Days(s)

But now the cace is need to disply only 3 digits after point like  2868.194, pls help me to get that result...

[Gysbert_Wassenaar]

Try num( sum(AHOT_MINUTES)/1440, '#.000')