Amount in blank spaces

[Former Member]

Hello Gurus,

This is my requirement.

I have one table.In this table i have field amount. In this field if the value is 0.00. I want to display as blank instead of 0.00.

Can anybody help me out in this requirement.

This is very urgent.I will reward you with points.

Thanks,

[Former Member · Accepted solution]

hi

Make the Data type of Amount Column as String in your data source and type cast all the values to this string in wdInit().

If you don't want to change your data type then try using

wdContext.currentContextElement.get<value>().valueof(string s);

you can pass null value as string parameter.

Regards,

Mandeep Virk

[Former Member · Accepted solution]

Hello Mandeep,

Can you tell me in which event this code should be written to achieve the functionality.Can you please explain me in detail so that i can work it out.

Thanks,

[Former Member · Accepted solution]

hi

you can write this code in wdInit() of your iview to initialize the values at runtime.

you change data type of your value attribute to string and in initialization just pass null parameters to required context element as you are passing to get 0.00 value.

In string when you pass null it will display blank instead integer shows null value as 0.00

Mandeep Virk