Number formatting and Decimal Point

[#1]

Hi all,

The below expression gives me the decimal output as (5.4%) when i used NumberFormatting---> Number ---> single decimal point(1.1%)

But how can i achieve this using Number formatting as auto.

sum({$<CanonicalDate={">=$(=date(Max(CanonicalDate)-30))<$(=date(Max(CanonicalDate)))"}, DateType={'completion'}>}course_completed)

/

count({$<CanonicalDate={">=$(=date(Max(CanonicalDate)-30))<$(=date(Max(CanonicalDate)))"}, DateType= {'invitation'}>} invitation_id)

I Tried Round, Ceil , and Floor  but i am getting different values.

And also i tried with

Num(sum({$<CanonicalDate={">=$(=date(Max(CanonicalDate)-30))<$(=date(Max(CanonicalDate)))"}, DateType={'completion'}>}course_completed)

/

count({$<CanonicalDate={">=$(=date(Max(CanonicalDate)-30))<$(=date(Max(CanonicalDate)))"}, DateType= {'invitation'}>} invitation_id),'#,##0.00%', '#,##0')

How can i achieve this requirement?

Thanks,

Pramod

[#2]

Yes the output of A matches when tried breaking the A into two.

0.054 and 0.055 is the correct value.

0.054 - 0.055 should be -0.001 but i am getting something like -0.0003636

I am getting wrong only while doing A-B

[#3]

In above image you can observe the count in textbox without num(), while doing subtraction it is using the 0.0542279... value how can i restrict that it should use only 0.054. Even i used num() for each expression also it's using the complete value.

[Anonymous]

Okay, can we try like this:

num((num(A,'0.0000')-num(B,'0.0000')),'0.0000')

[#5]

No balraj, i already tried with this expression it's getting the same value itself..

[Anonymous]

Quite Strange.

Any sample data/QVDs?

[#7]

Hi jagan,

Any help over this,

As when i used a single expression it is rounding to decimal point like 0.054 but when i used same expression with other expressions for calculations it's not working.

Any suggestions to achieve the needed.

Thanks,

Pramod

[#8]

Any suggestions over this?

[brunobertels]

Hi

Try floor your expression

Floor( 3.88 , 0.1 ) =  will give 3.8.

so try

floor(yourmesure,step) - floor(yourmesure,step)

bruno