Adjusting Numeric Result to Include Zero When Result is a Whole Number | Community
Skip to main content
K
khryc
Level 2
December 23, 2022
Question

Adjusting Numeric Result to Include Zero When Result is a Whole Number

  • December 23, 2022
  • 1 reply
  • 712 views

Hello,

I was able to remove the word Hours from my numeric results, but does anyone know how I can modify the text below so that my results include a decimal point and a zero (.0), when the result is a whole number? For example, instead of 7, I would prefer the result display as 7.0, without affecting numbers that are already fractions, such as 7.25?

aggregator.displayformat=minutesAsHoursString
aggregator.function=SUM
aggregator.valueexpression=ROUND(({workRequired}-{actualWorkRequired}),2)
aggregator.valueformat=compound
displayname=Remaining Hours
querysort=workRequired
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=work
styledef.case.0.comparison.lefttext=work
styledef.case.0.comparison.operator=lt
styledef.case.0.comparison.operatortype=double
styledef.case.0.comparison.rightmethod=actualWork
styledef.case.0.comparison.righttext=actualWork
styledef.case.0.comparison.truetext=
textmode=true
valueexpression=CONCAT(SUB({workRequired},{actualWorkRequired})/60)
valueformat=HTML

Thanks for any help.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Doug_Den_Hoed__AtAppStore
Community Advisor
Doug_Den_Hoed__AtAppStoreCommunity Advisor
Community Advisor
December 23, 2022

 

Very nice @khryc,

 

From this post listing the valid numeric valueformat options, I suggest you change the first line from

 

     aggregator.displayformat=minutesAsHoursString

 

to

 

     aggregator.displayformat=doubleAsFinancial

 

and (for consistency) the last line from

 

     valueformat=HTML

 

to

 

     valueformat=doubleAsFinancial

 

which should then force two decimals consistently at both the grouped (aggregator) and detailed level...one more than you really want, but all that appears to be available within the native settings.

 

Regards,
Doug

    K
    khrycAuthor
    Level 2
    December 23, 2022

    Thank you Doug...that worked.

     

    I tried applying the same logic to the following string,  so that it would have the double digit after the decimal (10.00), but it didn't seem to work, and when I try replacing valueformat=compound with valueformat=doubleAsDouble, it defaults back to compound. I'm just trying to have my 2 columns display consistently. 

     

    aggregator.displayformat=doubleAsDouble
    displayname=Planned Hours
    listsort=int
    querysort=workRequired
    textmode=true
    valueexpression={workRequired}/60
    valuefield=workRequired
    valueformat=compound
    viewalias=workrequired 

     

    Any ideas?

     

    Thanks for your help.

    Terms & ConditionsAccessibility statement

    Loading footer...