According to the salesforce docs it is possible to replace the integer of a exponential function with a merge field that is also an integer. Which is what i am trying to do
This is the formula
1/2^{mergefield}/7
formula works fine with a number (ie 1/2^7/7) not the mergefield. when i replace with the mergefield (which is a number and completed on the record) i get a null value.
This is within a loop in a flow, the merge field works fine if i merge it directly in the same formula without the rest of the formula.
Any suggestions what is going on here? seems like i cant replace the integer with a merge field...
https://developer.salesforce.com/forums/?id=906F00000008vDHIAY
thanks @Vaishnavi Bachu
linking that doc forced me to read it harder.
Exponent cannot be a fraction.... given i have /7 in the exponent... its almost always a fraction.... stupid limitation.
from that thread the way to make this work is
EXP((-({mergefield})/7)*LN(2))
for anyone who gets stuck the same
