Substract String with value Currecny

Help Studio
, ,
1

image
image1920×1080 216 KB

I have a problem when I want to reduce the currency value but the value is assigned in the form of a string, how can I reduce the value of the currency in the form of a string?

2

whats the value of IDRToleransiMutasi?

3

image
image250×572 7.7 KB

im assign with value = MappingRow2(“Transaction Amount”)

4

can you change this
image
to this
cdbl(IDRToleransiMutasi) - cdbl(IDRToleransiMutasi) = 1

5

okay I’ll try, thanks for the help, but I still don’t understand what the “cdbl” function is used for

6

and data type IDRToleransiMutasi generic value or string??

7

converts string to number so that you can subtract it

8

whats the current type? you can run the program first and see if it works

9

image
im use generic value type. btw im use this assign and failed, why?

10

if you do subtraction then replace AmmountMutasi with cdbl(AmmountMutasi)

cdbl(AmmountMutasi) - cdbl(AmmountMutasi) = 0.1 or cdbl(AmountJurnal) - cdbl(AmountJurnal) = 0.1

11

okay, last how about this :

image
image1280×720 181 KB

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.