Long decimal, even when using Round()

eradicator09 · February 7, 2018, 8:52pm

I’ve notice a weird result on one of my calculations for my newest Luna - RLSC.03 design. The formula for the moon age should be limited to 2 decimal points. However, I often see it displayed as 3 decimals spaces and sometimes a really long decimal (see the static page image):

Here is the formula:

Moon Age ((round(((((((367*#Dy#)-((7*(#Dy#+((#DM#+9)/12)))/4)+((275*#DM#)/9)+#Dd#+1721013.5+(#DH#/24)-(0.5*(((100*#Dy#)+#DM#-190002.5))/abs(((100*#Dy#)+#DM#-190002.5)))+0.5)-2458135.6)/29.53)-floor(((((367*#Dy#)-((7*(#Dy#+((#DM#+9)/12)))/4)+((275*#DM#)/9)+#Dd#+1721013.5+(#DH#/24)-(0.5*(((100*#Dy#)+#DM#-190002.5))/abs(((100*#Dy#)+#DM#-190002.5)))+0.5)-2458135.6)/29.53)))*29.53)*1000)/10)/100) Days

Facer_Official · February 7, 2018, 10:46pm

@eradicator09 are you seeing this on the Facer Creator? in the mobile app? on the watch app? Everywhere?

eradicator09 · February 8, 2018, 2:52pm

I get it in the creator and web link (when I time travel):

Same on mobile app. Its a little harder to test on watch itself since I can’t time travel.

YANA · March 6, 2022, 9:13am

Hi!
Did that your problem get fixed?
Why not sandwich it between the following formula?
((floor(YOURFORMULA*10))/10)
↑
floor or round

((floor(((round(((((((367*#Dy#)-((7*(#Dy#+((#DM#+9)/12)))/4)+((275*#DM#)/9)+#Dd#+1721013.5+(#DH#/24)-(0.5*(((100*#Dy#)+#DM#-190002.5))/abs(((100*#Dy#)+#DM#-190002.5)))+0.5)-2458135.6)/29.53)-floor(((((367*#Dy#)-((7*(#Dy#+((#DM#+9)/12)))/4)+((275*#DM#)/9)+#Dd#+1721013.5+(#DH#/24)-(0.5*(((100*#Dy#)+#DM#-190002.5))/abs(((100*#Dy#)+#DM#-190002.5)))+0.5)-2458135.6)/29.53)))*29.53)*1000)/10)/100)*10))/10)

russellcresser · March 7, 2022, 9:55am

Did a test on the Samsung Active for you. Thanks for the Formula. Intresting Idea below to Floor and Round. I have seen strange numbers on ylthe Apps. Usually to do with the SR SS Tags.

russellcresser · March 7, 2022, 9:57am

Now it is showing 3 Decimal. I wonder if it is down to Round as @YANA pointed out . Needs a test wit Floir. A bit busy at the moment. Hope to have a look later

russellcresser · March 7, 2022, 10:02am

I see on the Creator Time line I can generate the error you see .
Can I offer you a slightly more robust Formula that is a Modified version of a formula that the @ThaMattie gave me .