Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having a mind blank....
I want to store some calculations in excel/DB and then import them, basically to create a custom report format in a pivot table
All of the expressions are already in variables.
The upload spreadsheet for example is:
_ReportLevel | _ReportHeading | _ReportCalculation | _ReportFormat |
s | Weekly Profitability | ||
Issued | $(v_exp_jobinvoicedcount) | #,##0 | |
Value | $(v_exp_jobinvoicedvalue) | £#,##0;-£#,##0 | |
Avg Value | $(v_exp_jobinvoicedvalue) / $(v_exp_jobinvoicedcount) | £#,##0;-£#,##0 | |
a | Week Average | £#,##0;-£#,##0 |
What syntax do I then need to use to calculate the relevant variable if _ReportHeading is the dimension?
It's not quite clear for me what do you want exactly to do - but I think the following will be helpful for you: Re: Evaluate expression based on field value.
- Marcus
Hi Marcus,
I think that a pick match might be the only way in this case unfortunately, however I have just whipped up a basic example of what I hope to achieve.
In the attached example the pick match does work but it would be nice to make it more dynamic
=pick(match(_Header,'average','expression1','expression2'),$(v_expression1) / $(v_expression2),$(v_expression1),$(v_expression2))
Adam
Hmmm I wonder if I could dynamically build the pick match instead, at least that would offer some sort of automation
Close, but now I can't figure out the syntax to use the pick/match variable!
got it
=$(=$(v_pick_match))