Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following calculated dimension:
=aggr(only({
< InvoiceID=P({<Payment={'$(vRule01)'}>} InvoiceID )>
*
< InvoiceID=P({<Payment={"=replace(Payment,'.',vRule02)"}> } InvoiceID )>
*
< InvoiceID=P({<[Purchase Type]={'$(vRule03)'}>} InvoiceID )>
*
<InvoiceID=P({<InvoiceID={"CreatedBy=ChangedBy"}>} InvoiceID)>
)
} InvoiceID) ,InvoiceID)
What I need to do here is to replace the hard-coded "ChangedBy" field in the last set analysis, with a variable such as vRule04, where depending on some other external events would pass the ChangedBy field or some other field (like ApprovedBy) to the set analysis.
Can someone provide the correct syntax.
I think it would be
CreatedBy=$(vRule04)
Have you tried that?
-Rob
Had tried it before posting this with no success. Tried it again after your suggestion and now it works!. Thanks for your response and time.