Dear all:
Can I use formula directly when set excel model?
Useually,we do like this,&=DataSource.FieldName,
but i want to
-----------------------------------------------------------
A1
(&=DataSouce.MarginRate)/100
------------------------------------------------------------
Reason:
I have a field in datasource named Margin Rate,For example value is
0.01 ,and means 0.01%,
But when i set dataformat by percentage in excel, excel will *100 ,problem happen,
the data will show 1% and but the right string should be 0.01%