In Expression editor I have two calculated fields and the values are 19000 and 20000.
On dividing both it has to show 0.95.
But it is displaying error.
What I have tried:
This is my expression
[Agreed_Data] / [Current_Forecast_Data]
For Agreed Data the expression is
ToLong(Iif([txt_IPNumber_Status] = 'Agreed' And [txt_CalendarWeek] = [Present_Week], [int_IPNumber_Count], 0))
Here Present_Week is Parameter
For Current_Forecast_Data the expression is
ToLong(Iif([txt_IPNumber_Status] = 'Current Forecast' And [txt_CalendarWeek] = [Present_Week], [int_IPNumber_Count], 0))
I want to add display these values into dashboard textbox.
Please suggest me