Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community.
i am trying to get the value of (QTY * item-Cost ) which in this case its (2 * 239.410)=478.82 but its showing 478.8106.
having in mind that the item cost before formatting is 239.4051 and after its formatted in the back end ,using num''##.##0'' 239.41
any suggestion would be appreciated.
hello All ,
I thank each one of you for your valuable suggestion.
I came to find a solution for my Problem. for some reason QLIKSENSE was ignoring the formatting of the item cost even though it was done in the script. so my workaround was to force the item cost format while fetching from the database as I am fetching data from Oracle .
Sincerely
Change the format of the field in the properties from Auto to Number with 2 decimal places.
Have you already tried to use the measure formatting options from the chart menù?
it Shows 478.81
Im assuming its taking cost before formatting for some reason
anyway we can round this 478.8106 to 478.82
you can use Ceil function
=Ceil( 478.8106 ,0.01 )= 478.82
By default I would think that 478.8106 would round to 478.81 and not 82
i agree with you
I honestly think the same..but if i change the format of item cost to ##.##0 which makes it 239.41 and when multiply that by 2 it should show 478.82 not 478.8106
As shown in the picture..
hello All ,
I thank each one of you for your valuable suggestion.
I came to find a solution for my Problem. for some reason QLIKSENSE was ignoring the formatting of the item cost even though it was done in the script. so my workaround was to force the item cost format while fetching from the database as I am fetching data from Oracle .
Sincerely