Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have inherited a report that contains the following expression which works great. However, I am trying to replicate this in another report and can't figure out how. Can anyone help me understand what the vFlag component is here? It looks like a set variable but is neither stated in the load script nor in the external variables document.
I also have the same issue with the Section part.
Can anyone suggest what these mean?
Sum ({<BudgetNumber={$(vFlag)}, Section -={} >}BudgetAmount)
Thanks for your reply.
It isn't however I have just been shown by a colleague how this works, something I just haven't come across, but makes me feel like a bit of a noob!
Settings > Variable Overview...seems you can add a variable within the report itself. I had no idea!
HI @Daz4
I would add the variable to a text field and see if it is actually got a value in, If you can't find it in the variable editor then it looks like it is getting created.
I would guess at some point it is suppose to be picking up a value / values from the BudgetNumber field.
The section part doesn't make sense, but i guess they where trying to get where Section is not null
Hey Mark
Thanks for your reply.
It just comes up as '-' in a text field no matter what I select as a filter. It works as if it is picking up on the BudgetNumber but the problem is I can't see where it is defined anywhere.
Hi @Daz4 ,
Can you check if the variable vFlag is used anywhere in input box/variable input.
Thanks for your reply.
It isn't however I have just been shown by a colleague how this works, something I just haven't come across, but makes me feel like a bit of a noob!
Settings > Variable Overview...seems you can add a variable within the report itself. I had no idea!