04-14-2023 11:52 AM - last edited on 05-02-2023 10:22 AM by JackLacava
Hello, I an trying to write a calculation to divide one number by another one and have it to flow into a new account. Below is the formula I am using, but I am not getting the date to calculate. Can someone assist on how to write it correctly.
Calculate("A#mpg test","Divide(A#33010, A#33005)",deptFilter)
Solved! Go to Solution.
04-14-2023 11:54 AM
Without knowing what the variable "deptFilter" is, try this:
api.Data.Calculate("A#[mpg test] = Divide(A#33010, A#33005)",deptFilter)
04-14-2023 11:54 AM
Without knowing what the variable "deptFilter" is, try this:
api.Data.Calculate("A#[mpg test] = Divide(A#33010, A#33005)",deptFilter)
04-18-2023 01:28 PM
Hi Eric,
Unfortunately, neither of them didn't work. Should I write it in Business rules or in member formula?
02-20-2024 12:25 PM
hi
As Eric mentioned above without knowing the variable "deptFilter" is, and also assuming that you are trying to write a member formula in Account Dim then try this:
Return api.Data.GetDatacell("Divide((A#33010)",(deptFilter))").CellAmount
You cant state 2 Account like A#33010 & A#33005 and that the reason i have only mentioned one account to be divided by deptFilter.