Community & Support Portal

1. Derive the total number of days within a selected date range by excluding months (as per the requirement) Description:  Calculate the total number o...

1. Create custom aging values from date dimension w.r.t today’s date Description:  Define custom aging values (0-60 days, 60-90 days, etc.) based on tw...

1. Convert No. of Seconds to hours format (HH:MM:SS) Description: Convert the time given in seconds to hour format (HH:MM:SS). Example: Time i...

1. Find out the difference in values between two rows Description: Find out the difference in values between two rows (R1 and R2) in the crosstab i.e.;...

Calculating Profit/Loss Variance based on What-if Analysis   Description: Finding out the variance of profit or loss by deriving from columns like Act...

Sr No Input Output Expression Description Example Function Category 1 Gross Sales - Double e.g 70 Target - Double - e.g 100 Performance - e.g 70 % ...