Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I'm trying to calculate percentage values in a table.
I've created a variable called (AC - DWS) which calculates the total number of records for a measure. This calculates and I can output the results to a text box:
I'm using this variable to divide by the total records for a particular dimension., If I manually add the result as a number, the division works:
If I use the result of the variable, it doesn't:
Any idea why? It also doesn't work if I add the calculation used to get the variable value:
Count({1<[Ops Function]={'Drinking Water'}, DataSource={'Alarms'}, [Alarm Status]={3}, Date={'>=$(=Date($(vTodaysDate)))'}>} AlarmCount)
Any help gratefully received!
Did you try adding a '=' before your Count function in the variable?
=Count({1<[Ops Function]={'Drinking Water'}, DataSource={'Alarms'}, [Alarm Status]={3}, Date={'>=$(=Date($(vTodaysDate)))'}>} AlarmCount)
Hi Neil,
Can you please tell me or show me the expression how you are creating the variable ?
Did you try adding a '=' before your Count function in the variable?
=Count({1<[Ops Function]={'Drinking Water'}, DataSource={'Alarms'}, [Alarm Status]={3}, Date={'>=$(=Date($(vTodaysDate)))'}>} AlarmCount)
Hi Sunny,
Thank you - that worked. The odd thing is that it had already been working up till we had 3.0 installed, so perhaps the syntax has been tightened on variable creation.
I think this blogs talk about what we just saw
I'll read that one thoroughly! Thank you for all your help (again!)
No problem at all
Hi Rohit,
All solved thank you - Sunny (posts below) showed me the way....
Thank you for posting tho!
Neil