Calculate product in form |
Calculate product in form |
Sickstigma |
Apr 26 2024, 10:53 AM
Post
#1
|
Group: Members Posts: 4 Joined: 26-April 24 Member No.: 29,170 |
Is it possible, within the following code, to calculate the product of "COGS" divided by "Revenue" in "COGS%"?
[ <FormField> <Styles cellColor="Black" colorCodeUsage="0" imageCodeUsage="1" colSeqNum="1" colSpan="2" dataType="15" dataTypeName="Currency" hasColor="0" hasImage="0" hideIfEmpty="0" isSearchable="0" printOnly="0" labelColor="Black" rowSeqNum="32"/> <Name>Revenue</Name> </FormField> <FormField> <Styles colorCodeUsage="0" imageCodeUsage="1" colSeqNum="2" colSpan="1" dataType="15" dataTypeName="Currency" hasColor="0" hasImage="0" hideIfEmpty="0" isSearchable="0" printOnly="0" rowSeqNum="32"/> <Name>COGS</Name> </FormField> <FormField> <Styles colorCodeUsage="0" imageCodeUsage="1" colSeqNum="3" colSpan="1" dataType="2" dataTypeName="Number" hasColor="0" hasImage="0" hideIfEmpty="0" isSearchable="0" printOnly="0" rowSeqNum="32"/> <Name>COGS %</Name>] |
Christian J |
Apr 26 2024, 01:51 PM
Post
#2
|
. Group: WDG Moderators Posts: 9,722 Joined: 10-August 06 Member No.: 7 |
What is that code, React?
|
Sickstigma |
Apr 26 2024, 03:50 PM
Post
#3
|
Group: Members Posts: 4 Joined: 26-April 24 Member No.: 29,170 |
XML
|
Christian J |
Apr 26 2024, 03:57 PM
Post
#4
|
. Group: WDG Moderators Posts: 9,722 Joined: 10-August 06 Member No.: 7 |
XML can't do any calculations by itself, it's just a markup language.
|
Sickstigma |
Apr 26 2024, 06:33 PM
Post
#5
|
Group: Members Posts: 4 Joined: 26-April 24 Member No.: 29,170 |
Is there a compatible language that can do calculations?
And, hey!! Thank you for helping!! Sick |
Christian J |
Apr 26 2024, 07:53 PM
Post
#6
|
. Group: WDG Moderators Posts: 9,722 Joined: 10-August 06 Member No.: 7 |
Javascript or (better) a server-side scripting language (like PHP) might do it. Not sure how to use these with XML, but perhaps these pages can be helpful:
https://developer.mozilla.org/en-US/docs/We...serializing_XML https://www.php.net/manual/en/book.xml.php How do you currently transform the XML data into a web page? |
Lo-Fi Version | Time is now: 25th September 2024 - 10:57 AM |