Hi
I am Trying to Multiply Total Per Week field value by 4 and result display in Total Per Month Field. I tried different approaches but didn’t work. Workflow status show completed but Total Per Month field value remain 0.00.
Please note that Total Per Week and Total Per Month fields are data type of currency.
Snaps are attached.
Can you try this at formula?
{multiply({P0}; 4)}
For second picture, you first need to add Total per month in the Parameters. Then use it in the formula.
@rsp From the screen shot it doesn’t look like he has even set {P0}
NOTE: You have to set your parameters first, then used the parameters in the calculation.
Perhaps a review of the documentation will help you understand calculations better.
@rsp has the the correct formula. (provided you first ste {P0}
Hi,
Set Parameters:
Before you perform calculations, set a parameter for “Total Per Week”. Click on “Add Action” and choose Set Parameters.
For example, set {P0} to hold the value of “Total Per Week”:
Parameter: {P0}
Value: Total_Per_Week_Field (use the correct field reference).
Hello Abdullah,
for a general example and overview of the calculated fields, check out my video on it:
(or the text version if you prefer: SuiteCRM Workflow Calculated Fields to Boost Efficiency )
The formula and details for a solution as others already noted.