Hi everybody,
In my web application I am fetching the values the vales from another backend database. There are number fields containing employee salary details.
The fields like “basic”,“hra”, "ca"etc…
And there is a field “total”. In the total field I have to add all the field values. I am using the formula like
basic+hra+ca in total field, but it is not adding the values, it displays all the values, for this pls give the solution.
Hope soon
Sri
Subject: adding values problem
It sounds like the fields are set as “Text” not “Number”.
If you have 2, 4 and 6 as text, adding them will give “246”, but as numbers will give “12”
If the fields are setup as “number” fields, check what your lookup is returning - this may be coming in as text.
If all else fails, you could use
@TextToNumber(basic) + @textToNumber …
Subject: adding values problem
What is the formula for the total field?
Try something like this…
If(basic != “” & hra != “” & ca != “”; basic + hra + ca; “”)