Hello,
I want to write a formula with an if is not null condition along with to string and round also add a "%" symbol
We have 3 fields
1. Current amount
2. Previous amount
3. Variance ( current amount - previous amount)
new field should be a percentage with a formula like below, however I am missing some logic in closing the parenthesis. Please guide.
ToSTring(Round(if(!IsNull([Previous amount])) then
([Variance]/[Previous amount])*100,0.1)) + "%"
else [Current Amount]/[Previous amount])*100,0.1) +"%"
endif
Solved! Go to Solution.
Hi @Neelima1 Can you please share some samples (examples)
@Neelima1 - see screen shot and workflow attached. Thanks