I have the following line items- A,B,C. I need to create a new line item D which should take previous quarter values if C=0. PFA screenshot.
@tampara.dora
Since the module is set at quarter, you can use the PREVIOUS function.
If C<>0 then C else PREVIOUS(C)
Make sure you set the first condition as the most likely. If C is most likely not zero then that should be first like the above example.
Aha! a year to year approach. Love it.
In that case use OFFSET. Go back 4 periods.
Hello, Is there a quick way, in Anaplan XL to divide all the results by 1000 without creating a measure for every row or every column?
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.